"Marcus Maginniss" wrote in message
...
I am trying to link an excel file to an access database.


OK...


Because of data type issues, I had to save my .xls file as
a .csv file.


What issues?


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.


What is the problem you are encountering?


Any ideas how I can link to
the .xls file while keeping my data intact?


Can't you just link to the excel file from Access?