creating Access tables from delimited files

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
cronid
Forum Newbie
Posts: 1
Joined: Sun Dec 26, 2004 6:47 pm

creating Access tables from delimited files

Post by cronid »

I have 61 pipe delimited files in a Windows 2000 folder. I need to write a php script to create 61 Access tables, which I have done manually in the past. Each file is different with a different number of rows and columns. It is not necessary that the columns be named anything but the default field 1, field 2, etc.

I already have 61 Access queries in the folder for the rows count in each table, 61 queries for duplicates and for the tables 2 through 27 for the rows without a match in field 1 of the first table. I need to have a script create the tables, run those queries and hopefully post the results to an Excel spreadsheet each time the 61 files are overlayed.

Does anyone have a sample script that does something similar?

Thanks in advance,

Den
SurfPro
Forum Newbie
Posts: 2
Joined: Sat Jan 22, 2005 2:59 pm

Creating Access Table from Delimited Files

Post by SurfPro »

Unfortunately it looks like no one has a script. You've probably already thought of this but whenever I want to make a table out of a delimited file I just use the "Get External Data" command in Access.

If nothing else this post will push your question back to the top and someone may have a script for you :-)

good luck

Regards.

http://www.addmap.com
Post Reply