Importing 2 files

[KEA Scott]

I am trying to import 2 files into the same table. The first file is a list of line items that are distinguished by an order number field then a line item field. Here is what the file looks like.

9000,1,"Belt","Belt",1,$3.95

9000,2,"Tax","Tax",1,$0.00

9000,3,"Shipping","Shipping",1,$7.60

9001,1,"Shoe","Shoe",1,$16.00

9001,2,"Tax","Tax",1,$0.00

9001,3,"Shipping","Shipping",1,$13.75

9002,1,"trgofoalta","DP-TAB-GODDESS",1,$34.95

9002,2,"ls-minispsin","LS-MINISPSIN",1,$0.90

9002,3,"ls-minispsin","LS-MINISPSIN",1,$0.30

9002,4,"hmugc","HMUGC",1,$3.95

9002,5,"ic3310","IC3310",1,$3.95

9002,6,"Tax","Tax",1,$0.00

9002,7,"Shipping","Shipping",1,$13.15

The second file has the same order number and line item number fields (but not ever line in the line items will be in the option field). The first import works fine. When I try to import the second file matching both the order number and line number it updates nothing. Anyone have an idea. Here is the second data.

9002,2,"ls-minispsin","LS-MINISPSIN","Colors","Silver (+.60)"

9002,3,"ls-minispsin","LS-MINISPSIN","Colors","Yellow"

[Emma in England]

I made a quick database with 6 fields and imported the first file to populate it. Then the 2nd with update matching records checked, and the first 2 fields to match. It worked as I would expect - the

9002,2

and

9002,3

records now hold 'Colors' etc, not '1' and a price.

It seems odd that you are apparently overwriting what look like quantity and price with what looks like text??

[KEA Scott]

I am not trying to over write fields all data except for the first 2 in each file go into their own fields. We download files for our orders and the system that we use (yahoo stores) breaks out all the information into different files (I have never had a company do this before.

[KEA Scott]

Okay I am sorry I was tired and not looking at the matching fields. I guess that is what I get for being tired.

Thanks for your help