import excel speadsheet (1 Viewer)

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.

pbaldy said:

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

Click to expand...

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.