Recent content by goryon
-
G
Import Dbase IV with file extension not .dbf
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...- goryon
- Post #6
- Forum: Modules & VBA
-
G
Import Dbase IV with file extension not .dbf
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...- goryon
- Post #3
- Forum: Modules & VBA
-
G
Import Dbase IV with file extension not .dbf
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...- goryon
- Thread
- Replies: 5
- Forum: Modules & VBA
-
G
How to import dbf files automaticly?
Hello! In VBA it's easy to do it: You can link to an external .dbf file(dbase), just need to know which exactly DBase version it is, then use the command below, and you get a table in the Ms Access where you can make your questions with queries. DoCmd.TransferDatabase acLink, "dBase iV"...