Page 1 of 1

creating Access tables from delimited files

Posted: Sun Dec 26, 2004 6:51 pm
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

Creating Access Table from Delimited Files

Posted: Sat Jan 22, 2005 3:12 pm
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