Hi,
I hope someone can give me some solutions to these problems I faced.
I imported some data to Excel. Then in Access, I table-linked to this file. I have two fields which in Excel is in number format but in Access, these fields property is text and the values in these fields become "#Num!". Others number format fields were okay, only these two fields (or particular columns?).
But if I linked directly to the datasource, it seems the properties remains as number format. However, i do not want to linked directly to the main datasource as I only want specific fields (about 20 out of 100 over fields). The Access file size become very big after refresh.
Another issue with direct linked to the main datasource is I can't see all the fields although I can see all fields in Excel when I do a database query.
Any ideas on this?
Thank you in advance for your help.