Adding info to imported text.

[mfoot77]

I receive invoices in a .txt file in which I import to Access to pull out
Stock Keeping Units (SKUs) along with some additional information (i.e.
description, value, country of origin, ect.) on the same line. The problem is
the store number is not included on the same line. Though the store number is
in the listed in the header. Is there a way I can pull the store number from
the header and adding it to all the sku lines prior or during importation?

 

[John W. Vinson]

I receive invoices in a .txt file in which I import to Access to pull out
Stock Keeping Units (SKUs) along with some additional information (i.e.
description, value, country of origin, ect.) on the same line. The problem is
the store number is not included on the same line. Though the store number is
in the listed in the header. Is there a way I can pull the store number from
the header and adding it to all the sku lines prior or during importation?

Given that you have not posted any description of the structure of the file or
how you're importing it, I'm not sure anyone here could possibly help other
than to say "open the file in VBA code and parse it". More info please?

 

[IT-1957]

Since the header is, well, the header, I will do this in two steps.
Get to linked tables to the text file, 1 with the headers, and with out.
Do a query based on the linked table with the headers and select to show
only the firs record (this will hava the data you need)
Create a empty table forr all the columns that you need (including store
number)
The do a second query based on the text file with not header, add the firts
query with the header data, and select "append" as the query type, add all
the columns that you need, run it.

It will create a table with all the recors with the store number as one of
them.

good luck.

And I know, it may be very basic stuff but it works.

 

[a a r o n . k e m p f]

you should learn a real ETL tool like DTS or SSIS or Informatica.

Jet is dead and it has been for a decade

 

[George Hepworth]

It was Mark Twain who first complained that reports of his death were an
exaggeration. Inasmuch as Jet, being an inanimate software application,
can't speak for itself in this regard, however, permit me perform the duty
of stand-in.

Reports of the death of Jet are not merely an exaggeration; they are an
outright fraud.

At least Mr. Twain had the dignity of being misquoted by a reporter for a
New York newspaper who was apparently confused by the death of a cousin of
Twain's.

Fear not, mfoot77, Jet is not even terminally ill. Moreover, Jet now has a
cousin, called ACE, which promises to have an even longer life than the
venerable Jet has had.





message
you should learn a real ETL tool like DTS or SSIS or Informatica.

Jet is dead and it has been for a decade