Transfer Text Macro

[dman]

Hi.

I had a macro setup to import a text file into a table, however, I found out
one the fields in the table will not be available in the text file. Instead
of providing
SSN# in the text file, I will have Employee ID.

There is an Employee table that I can 'lookup' the SSN# from the Emp ID. Can
this
be done in a macro during the import, or do I have to write some VBA code to
accomplish this?

Thanks.
D

 

[Ken Snell \(MVP\)]

Create a query that will provide you with the desired data from the tables,
and export the query's data. In TransferText, you can use a query name or a
table name as the source of the data.

 

[dman]

Thanks!

I used your idea and created an update query.

My marco has 3 steps now...

TransferText....import the text file to table A
OpenQuery...run the update query to merge info(ssn) and update needed table
OpenQuery...deletes table A

 

[Ken Snell \(MVP\)]

Dumb me... I just reread your original post and you did say you were
importing, not exporting. My mistake (late hours is my excuse), but glad you
were able to get a solution anyway!