Import ^ Delimited TXT file and then manipulate columns

[WSS_Login]

Hello,
I have a caret delimited file that contains 5 columns of data ("A")
I have used Access's Function "Get External Data" Import" from the file menu.
Going through the prompts, I am able to successfully bring the data in and view on screen.
A

Data A	Data B	Data C	Data D	Data E
Field 1	Field 2	Field 3	Field 4	Field 5

What I am trying to accomplish is this....
I currently have another separate table that I created before and it appears as shown below
B

Field 1

Field 2

Field 3

Field 4

Field 5

Field 6

Field 7

Field 8

I need to get what imported in "A" and bring it over to "B" with some exceptions.
Below is the "Data" (1st row) that I need to re-route or bring over to my existing Table (2nd row).

Data D	Data C	Data A			Data E		Data B
Field 1	Field 2	Field 3	Field 4	Field 5	Field 6	Field 7	Field 8

Is this possible? If so, how can I accomplish it? I have read through a few books, Googled for hours and just cannot seem to make it work.
Maybe I am going about it wrong, but I think Tables is how I am to accomplish this. I also tried Relationship, but that did not work...at least the way I did it.
If this is not the best method, can someone also direct me to the proper way of handling this data move/linking?

I greatly appreciate the help and assistance.
Best Regards,
John

[ranman256]

Save the file to a generic filename like c:\temp\File2import.txt
link the file as an external table (with Spec name)
make an append query to put the data in the correct fields,
make a macro to run the query.

then the steps will be:
1. Save new CSV to the generic file
2. Run macro.
done