Import to a New Table

[Craig]

Can a Schema.ini file be used to import into a new table or just existing
tables.

I am using the "How to create a schema.ini file programmatically" at
http://support.microsoft.com/default.aspx?scid=kb;en-us;155512, which works
for importing into an existing table, but what if i want to import into a
new table.

Problem: I have to import many files, from many sources, which are never the
same format.

Solution Required: to be able to import the many files into individual
tables and format the data all as "Text"

Any help would be greatly appreciated

Thanks
Craig

 

[Jeff Boyce]

Craig

You've described a "how". If you describe your "what", without any
reference to Access or other tools, just the underlying business need, the
newsgroup readers may be able to offer alternate approaches to the one you
appear to have already settled on...

Regards

Jeff Boyce
Microsoft Office/Access MVP