Table Import

  • Thread starter Thread starter Bill Mills
  • Start date Start date
B

Bill Mills

I am trying to import several seperate Paradox tables into
access and append all the tables into one table. There
are 35 seperate paradox files with 1 table in each file
and all are the exact same table structure. I want to
import all 35 files into 1 access table. Any ideas on the
easiest way to do that? Any help would be geatly
appreciated.
 
'untested since I don't have Paradox
DoCmd.TransferDatabase acImport, "Paradox 7.x", strLocalDir, acTable,
strFileName, strTableName

You can run this code manually 35 times if it just a 1 time thing.
If you plan to repeat the process then you should write a loop to read each
file in folder and then call this.
 
Hi,

My name is Amy Vargo. Thank you for using the Microsoft Access Newsgroups.

It sounds like you need to apply the latest Jet update. For more
information, please see the article below.

811120 Access may cause an error when you open or delete or compact linked
http://support.microsoft.com/?id=811120

Also, if the path to the file is greater than 128 characters, reduce the
names so that the complete path from the driver to the folders to the .mdb
file is less than 128.

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Amy Vargo
Microsoft Access Engineer


This posting is provided 'AS IS' with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.
 
Back
Top