import excel speadsheet

narsing18

New member
Local time
Tomorrow, 02:38
Joined
Jun 30, 2017
Messages
3
Hi,

i have imported excel spreadsheet to access which have table data,what i want to know is does it have all properties of access , i mean multi user access. or it is still a excel sheet.

i am new to access and dont have much knowledge.

Thanks.
 
If you import the Excel data into an Access table, it will have all the properties of Access.
 
If you import the Excel data into an Access table, it will have all the properties of Access.

Thanks for the update...i will try ti retrieve the data.
 
Please be aware that importing data from Excel to Access potentially could change the format of the data depending on the consistent (or inconsistent) format of each column. That is, if you have a column of numeric data but some columns have an X or some other symbol in them to signify data absence, depending on the location of that symbol, the column could be stored as text.

Also, be aware that imported tables don't have indexes or keys, and their column (field) names depend on options you used during the import.

Other than those warnings, I agree with Paul. Once imported, the spreadsheet becomes a true Access table.
 

Users who are viewing this thread

Back
Top Bottom