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 tables from delimited files
Moderator: General Moderators
Creating Access Table from Delimited Files
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
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