"Pete" <pe********@comcast.netwrote in
news:11*********************@m58g2000cwm.googlegro ups.com:
I need to import multiple tab delimited files for which I do
not have the formats. All files have column headers in the
the line. The files must be dynamic. The only common value
is that the files are text and use tabs to delimit the column
data.
I can not use the File/Import as people using the program do
not have the necessary experience to perform this function.
Therefore, I need to programtically create unique tables for
each text file.
I'd attack this by using the low-level file manipulation
functions in VBA (open #1, get #1) to read each line of the file
into a string variable or one column table, then use a loop to
read the column names, create the table from that (but here
you'll have to guess at the column type), then loop through each
row to find the tabs, writing out the values to the appropriate
column.
It is much too much code to post on a newsgroup.
--
Bob Quintal
PA is y I've altered my email address.
--
Posted via a free Usenet account from
http://www.teranews.com