Multiple tables in one text file

  • Thread starter jackson via AccessMonster.com
  • Start date
J

jackson via AccessMonster.com

Hi,

I have a text file that has a couple of tables in the single file, two of
which I need to extract. Clearly the most elegant way to do this would be in
VBA and somehow set the range of each table and import into two tables, can
anyone give me some pointers on where to start with this please? (not that
good at VBA).

Otherwise I figure I could do it messily by importing the file as is and then
using a few queries to pull out the data and append into tables which would
involve Dlookups and record counters I suppose.

Any help/advice appreciated.

Regards,
Jackson
 
D

Dorian

Is this a one-off task or an ongoing requirement? If its one-off, just copy
the file then delete the unwanted records.
If it's ongoing, I'd recommend getting the data in two separate text files
to begin with. Whoever is loading the file should load 2 separate files.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 
J

Jackson via AccessMonster.com

Hi Dorian,

Two seperate text files would be impossible and it's an ongoing thing, would
be a daily import. Any ideas given that?
Is this a one-off task or an ongoing requirement? If its one-off, just copy
the file then delete the unwanted records.
If it's ongoing, I'd recommend getting the data in two separate text files
to begin with. Whoever is loading the file should load 2 separate files.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
Hi,
Click to expand...
[quoted text clipped - 12 lines]
Regards,
Jackson
Click to expand...
Click to expand...
 
Top