Search results

The final exported data will be used by a seperate application which requires the data in a .dbf file.

Look at the Retrieving Extended File Properties example at Microsofts website. http://www.microsoft.com/technet/scriptcenter/guide/sas_fil_lunl.mspx?mfr=true

The other post is in the forum, and pertains to, VB code. While this post is an offshoot of the other post, in general it has nothing to do with VB code. Hence the General forum.

Spaces, right now we are using FileMaker for our DB and I am able to use spaces in table names and import new tables from files that have a space in the file name. Linked Tables. Linked tables do not give me the option to link to an existing table so I don’t see how that gains me anything. The...

Anyone? Ferris? Bueller? It just doesn't make sense that you can import a .dbf file structure and the resulting records but then not be able to import more records into an existing table. Whats the deal?

OK, I changed the table name to "ASN_Label_Data" but still get a new table for each file. Why should I avoid spaces in the table name? Does this apply to other things like Forms and Reports? No Import Errors reported. I can't even do a manual import into an existing table. Everytime I get a new...

There is no File>Import The only option I seem to have is File>Get External Data>Import. This brings up the Import dialog box, there is no wizard. Whenever I select a file it automatically creates a new table, no option given to import data into an existing table. ----------- After further...

Access 2000 This has to be an easy one but I can't seem to figure it out. I created a table by importing the structure from a .dbf file. Now I simply want to import other .dbf records from a bunch of .dbf files that have the exact same structure. How do Import these records into my existing...

I tried what you suggested. While this does import all the files it creates a new Table for each imported file. I want to import all the files into a previously created table named ASN Label Data. DoCmd.TransferDatabase acImport, "dBase IV", InputDir, _ acTable, ImportFile, "ASN Label Data"

Want to automate the import of 1 to many .dbf files in a single shot (all the files have the same fields). found the following code at Microsofts site but this is not exactly what I'm looking for. I dont want to create new tables I just want to import all the records from multiple files and then...