Import Dbase IV with file extension not .dbf

[goryon]

Hello all

I'm using the function TransferDatabase to import some DBase IV files into Access, and it's working fine.

Until now...
Now I have the same type of files, but are stored with several different file extensions.

If I change the file extension to *.dbf it works nice, but this isn't very good for my application as the files are shared...

Is there a way to do this?


Thanks in advance.
Márcio

 

[RuralGuy]

How about making a copy and rename it in the process and delete it after the import.

 

[goryon]

The data is stored in daily files with sizes from 30kb up to 1Mb.

I wnat to handle up to one year at once, and it makes the process too slow...

 

[RuralGuy]

Are you using the latest ODBC driver? What is the current extent of the files?

 

[gemma-the-husky]

cant you explicitly name the dbf file in your docmd.method

ie "myfile.ext"
or does that look for myfile.ext.dbf?

 

[goryon]

The file name is explicit e.g.: '20080103.WSD'

When executing the DoCmd.TransferDatabase get this error:
Error 3011: the Microsoft Jet database engine could not find the object '20080103.WSD'. Make sure the object exists and ...

If I simply change the file extension of the file to .dbf it works fine...