How to set reference to XL 95?

  • Thread starter Thread starter ckerns
  • Start date Start date
C

ckerns

I am using AC2003. I need to connect to an XL spreadheet that was
built in Excel 5 or 95. (I am not able to convert this file to 2003
so I have to to set this reference.)

Can this be done?

tia
 
By "connect", I assume you mean link?

1. From the Database Window, select the [Tables] tab.
2. Click [New], then select [Link Table].
3. From the [Files of Type] drop-down, select "Microsoft Excel (*.xls)".
4. Browse to and select the spreadsheet, then click [Link].

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html
 
Thanks for your reply!

Heres the poop on the xl file.

The first 7 rows are headings, dates, and other pretty stuff.

I want to establish a CreateObject/GetObject connection, get rid of
the fluff, and then do the import. I can do all this in ac2003, but
the xl file must be opened and then saved as other than 05 or 95
flavor before this will even work.

That's why I want to make the reference to Excel 05. Otherwise I get a
1004 error.

In ac2003, what do you recommend to close Excel after I have imported
into access. This is what i use, but I have intermittent results:

Excel.Application.Quit

Any thoughts on this?

tia

By "connect", I assume you mean link?

1. From the Database Window, select the [Tables] tab.
2. Click [New], then select [Link Table].
3. From the [Files of Type] drop-down, select "Microsoft Excel (*.xls)".
4. Browse to and select the spreadsheet, then click [Link].

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html


I am using AC2003. I need to connect to an XL spreadheet that was
built in Excel 5 or 95. (I am not able to convert this file to 2003
so I have to to set this reference.)

Can this be done?

tia
Click to expand...
Click to expand...
 
Excel.Application.Quit is correct, but you will have an object variable,
called "xl" (or something similar), which would make it:
xl.Quit

....but don't forget to kill the reference when you're finished:
Set xl = Nothing

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html


Thanks for your reply!

Heres the poop on the xl file.

The first 7 rows are headings, dates, and other pretty stuff.

I want to establish a CreateObject/GetObject connection, get rid of
the fluff, and then do the import. I can do all this in ac2003, but
the xl file must be opened and then saved as other than 05 or 95
flavor before this will even work.

That's why I want to make the reference to Excel 05. Otherwise I get a
1004 error.

In ac2003, what do you recommend to close Excel after I have imported
into access. This is what i use, but I have intermittent results:

Excel.Application.Quit

Any thoughts on this?

tia

By "connect", I assume you mean link?

1. From the Database Window, select the [Tables] tab.
2. Click [New], then select [Link Table].
3. From the [Files of Type] drop-down, select "Microsoft Excel (*.xls)".
4. Browse to and select the spreadsheet, then click [Link].

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html


I am using AC2003. I need to connect to an XL spreadheet that was
built in Excel 5 or 95. (I am not able to convert this file to 2003
so I have to to set this reference.)

Can this be done?

tia
Click to expand...
Click to expand...
Click to expand...
 
Back
Top