Table Import

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bill Mills - 27 Sep 2004 22:04 GMT

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.

Reply to this Message

Joe Fallon - 28 Sep 2004 05:14 GMT

'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.

Signature

Joe Fallon
Access MVP

>I am trying to import several seperate Paradox tables into
> access and append all the tables into one table. There
[quoted text clipped - 3 lines]
> easiest way to do that? Any help would be geatly
> appreciated.

Reply to this Message

Amy Vargo - 29 Sep 2004 18:20 GMT

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.

Reply to this Message