|
In the meantime, I'll upload this MS Access file that contains what I do. Under Macros, if you run CreateAllTables, it will set up all the tables. Then run ImportAll to import the data. Two catches are that you have to make the corrections I mentioned above and the csv files have to be in c:\OOTPdata on your hard drive (so move them there first).
Also, it helps if you turn off warning messages for action queries so that you don't get a bunch of them, since the macro runs a series of queries.
__________________
My music
"When the trees blow back and forth, that's what makes the wind." - Steven Wright
Fjord emena pancreas thorax fornicate marmalade morpheme proteolysis smaxa cabana offal srue vitriol grope hallelujah lentils
|