Importing Files and seperating contents to 2 tables

[Justin]

I have this problem. I have this database where user will import 35 files
daily (have a form for uploading). Now, this process takes about 30 secs,
max.
Thing is that I am importing the files twice. reason is that I have to take
the top part, append taht data to table 1 and then the bottom part, append
that to table 2.
Unfor, the columns aren't linedup to do one "import specification". That is
why i have 2 import specification for the 2 uploads.
Wondering if there is a way to have it so that, I import the files straight
to one tables, without break lines for columns, then have some coding to tell
which parts go to which tables

 

[Marshall Barton]

I have this problem. I have this database where user will import 35 files
daily (have a form for uploading). Now, this process takes about 30 secs,
max.
Thing is that I am importing the files twice. reason is that I have to take
the top part, append taht data to table 1 and then the bottom part, append
that to table 2.
Unfor, the columns aren't linedup to do one "import specification". That is
why i have 2 import specification for the 2 uploads.
Wondering if there is a way to have it so that, I import the files straight
to one tables, without break lines for columns, then have some coding to tell
which parts go to which tables

What kind of files are you importing?

If they're text files, you may want to consider using the
File I/O statements (Open, LineInput, etc.) instead of
TransferText.

If they're spreadsheet files, there are several alternatives
to TransferSpreadsheet, but more details would be required
to determine which one to use.

If the files are some other type, a lot more details are
needed.

 

[Justin]

They are text files

What kind of files are you importing?

If they're text files, you may want to consider using the
File I/O statements (Open, LineInput, etc.) instead of
TransferText.

If they're spreadsheet files, there are several alternatives
to TransferSpreadsheet, but more details would be required
to determine which one to use.

If the files are some other type, a lot more details are
needed.

 

[Marshall Barton]

Did you look into using the VBA File I/O statements?

If you are unfamiliar with using VBA to create customized
operations that go beyond the simple built-in features, try
posting the file format and your data table's details and
see if someone can help you write the code.