Linking Excel to Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pietro - 11 Sep 2007 09:02 GMT

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?

Reply to this Message

ColinD - 11 Sep 2007 12:06 GMT

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.

> Hi all,
>
[quoted text clipped - 5 lines]
>
> Can anybody help?

Reply to this Message

Pietro - 11 Sep 2007 13:36 GMT

tahnk you for your reply
Could you please explain to me what do you mean by CSV?
Thanx

> 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
[quoted text clipped - 9 lines]
> >
> > Can anybody help?

Reply to this Message

Douglas J. Steele - 11 Sep 2007 13:40 GMT

Comma Separated Values.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> tahnk you for your reply
> Could you please explain to me what do you mean by CSV?
[quoted text clipped - 17 lines]
>> >
>> > Can anybody help?

Reply to this Message