Import tab delimited multiple files using VBA

[Pete]

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.

 

[Guest]

I would first double check that the table imports ok via a basic manual
attempt.....

Once that is established - you can automate it via Access' Macro object...in
there you will find that one of the given options is an 'import file'
feature....

 

[Pete]

I would first double check that the table imports ok via a basic manual
attempt.....

Once that is established - you can automate it via Access' Macro object...in
there you will find that one of the given options is an 'import file'
feature....

--
NTC






- Show quoted text -

I works ok manually, once i set the tab indicator. Otherwise,
everything goes into the first column.

 

[John Nurick]

Hi Pete,

As far as I know the choice is between converting the tab-separated
files to comma-separated (which can be imported or linked without
further ado), and writing code to analyse a tab-delimited file and
create the appropriate schema.ini so it can be imported.

There's a VBA function to do the former at
http://www.j.nurick.dial.pipex.com/Code/

 

[Pete]

Hi Pete,

As far as I know the choice is between converting the tab-separated
files to comma-separated (which can be imported or linked without
further ado), and writing code to analyse a tab-delimited file and
create the appropriate schema.ini so it can be imported.

There's a VBA function to do the former athttp://www.j.nurick.dial.pipex.com/Code/

thanks