Linking Excel to Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

I'm trying to link an Excell sheet (2003) to an Access 2003,but i always
get an error message that says that the Excel sheet format is not in the
expected format,I checked the format of the excel sheet it's xls
While i can link other sheets to the same database!!!
Actually the sheet i;m trying to link is exported from a SQL tool

Can anybody help?
 
Try exporting the sheet to a CSV file, then open the CSV file and save it as
an .xls. This should ensure that you have a file in the right format, not
something a little odd that your SQL tool has created.
 
Back
Top