I am trying to link an excel file to an access database.
Because of data type issues, I had to save my .xls file as
a .csv file. When I do this, I can link Access to the data
in the .csv file fine. The only problem is I really want
to keep the data as an .xls file. I keep getting this
#null error in my data when I link to the .xls file. I
have tried the transferspreadsheet method but it really
doesn't deal with data types. Any ideas how I can link to
the .xls file while keeping my data intact?