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> ¼¶¼g©ó¶l¥ó·s»D
: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
