excel link to access

  • Thread starter Thread starter Marcus Maginniss
  • Start date Start date
M

Marcus Maginniss

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?
 
Marcus Maginniss said:
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.
Click to expand...


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.
Click to expand...


What is the problem you are encountering?

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


Can't you just link to the excel file from Access?
 
I am no expert in fact I am very much a novice. What I have done in the
past is: if you right click in the the window that shows your tables,
queries ect... select the link tables... Then navigate to your file and
select it. It will walk you through the process.
macamarr
 
Back
Top