I have an old dbf program that provides me with a dbf ouptut on a daily basis. Each file is identical, but the file name is different by using the following naming convention: MMMDDYY.dbf, for example, OCT2710.dbf.
My OS is Windows Server 2008 R2 64 bit
My version of SQL is 2008 R2 64 bit
The DBF files appear to be DIII (I am able to use this type to import into an access database, one file at a time, and it creates a new file, not appending).
I have about 2 years worth of dbf files that I would like to import into a single sql table in order to be able to create some reports. What I'm looking for is a macro that will enable me to run it against a file folder and import all of the dbf files until
it has imported them all. I want to do this as an append as each of the files have identical layout and so append should work fine. I have tried to do an import via 32 bit as well as 64 bit import wizard but can't seem to figure out how to do it. I have created
a 32bit odbc to the folder but the sql import for both 32 bit and 64 bit won't recognize the odbc connection.
Has anyone got any ideas about how to resolve this? I did manage to find an old sql 2000 server that was able to do the import, but it was quite a manual operation.
View Complete Post