By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,505 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 IT Pros & Developers. It's quick & easy.

Cannot link tables in Access 2002

P: n/a
I'm having a problem with some .DBF tables and Access 2002. When I try to
link them as external data, Access reports "External table is not in
expected format", help says the table has changed since it was last changed,
but it is being linked for the first time????

I can open these tables in Excel and Lotus Approach and the name complies to
8:3. I believe the application which created these tables was possibly a
foxpro one.

Please help before I give up and use something else to link these tables.

Jackson

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
I think if you can open the file in Excel, try to link a Excel file in
Access. I think it is work. Just select it is a Excel file.

hope can help u!!


"Jackson" <sp***************@virgin.net> 撰寫於郵件新聞
:bs**********@newsg4.svr.pol.co.uk...
I'm having a problem with some .DBF tables and Access 2002. When I try to
link them as external data, Access reports "External table is not in
expected format", help says the table has changed since it was last changed, but it is being linked for the first time????

I can open these tables in Excel and Lotus Approach and the name complies to 8:3. I believe the application which created these tables was possibly a
foxpro one.

Please help before I give up and use something else to link these tables.

Jackson

Nov 12 '05 #2

P: n/a
When you select Excel as a file type it is expecting a .XLS file and not a
..DBF file. I should have said that I can select and link to other .DBF files
created in earlier programs.

"Victor" <ab*@abc.net> wrote in message
news:bs*********@imsp212.netvigator.com...
I think if you can open the file in Excel, try to link a Excel file in
Access. I think it is work. Just select it is a Excel file.

hope can help u!!


"Jackson" <sp***************@virgin.net> 撰寫於郵件新聞
:bs**********@newsg4.svr.pol.co.uk...
I'm having a problem with some .DBF tables and Access 2002. When I try to link them as external data, Access reports "External table is not in
expected format", help says the table has changed since it was last changed,
but it is being linked for the first time????

I can open these tables in Excel and Lotus Approach and the name complies to
8:3. I believe the application which created these tables was possibly a
foxpro one.

Please help before I give up and use something else to link these

tables.
Jackson


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.