I'm not sure exactly how to go about this, but how would you import a text file into a table using a the schema.ini method.
I already have a schema.ini created using the table the text files information will be stored in as a reference. I created it programmatically.
I can create a recordset from the file, and can browse around it. But I can't seem to figure out how to get all the info into a table in a few steps. I could use a For...Next loop w/ the recordset, but I'm not sure if that would be the best.
I think there is a way I just can't seem to figure out the code to do it. I've tried the transfertext method, which the Access help files say can use a schema, but it doesn't appear to work.
I also don't want to do it with the Import/Export wizard, and specs. I tried using that at first, all it did was give me grief. Kept throwing away my changes, I could edit fine, but everytime I added a few more fields they got tossed!
Thanks for any and all help, its bringing back from insanity!