importing table into MS Access

[ken2834]

I am writing a fairly simple VBA app in Access to retrieve a tab file from a Unix server via FTP, import the file into a table, then run a report off the table. When I try to import the table, I get the following error:

The Microsoft Jet engine could not find the object 'X:\Data\InternalReports\PaymentReport\COCASH.payment.081406.tab'. Make sure the object exists and that you spell its name and the path correctly.

I get this error whether I attempt to import in the code or import manually. I don't understand how it cannot find the file, when I import manually, I am browsing to the file. Perhaps access can't handle a file with multiple '.' in the name?

Any ideas? Thanks.

 

[Remou]

As far as I recall, Access like to have things ending with the 'right' extention, .csv,.txt and so on. You can meddle with the registry or you can rename prior to importing.

 

[Ed2020]

If you choose to make the registry changes I can give you the .reg file to do this. Of course this will need to be applied to all machines you run the system on.

If this is the only time you'll want to do this, or there are lots of users I'd stick with Remou's suggestion of renaming the file (programmatically?).

Ed Metcalfe.

Please do not feed the trolls.....