467,229 Members | 1,389 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,229 developers. It's quick & easy.

Cannot link tables in Access 2002

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
  • viewed: 1761
Share:
2 Replies
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
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.

Similar topics

1 post views Thread by Clive Moss | last post: by
reply views Thread by Bryan | last post: by
3 posts views Thread by debbie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.