URGENT PLEASE: import problem

[yafreax]

here's the deal, we have an excel file that has one column of store numbers, and a second column of various numbers... lets say for ease sake they have 5 stores and 10 numbers. so the excel sheet looks like this:

STORE -- number

a -- 3

b -- 4

c -- 1

d -- 6

e -- 2

-- 5

-- 9

-- 7

-- 10

-- 8

what they want is store A to get each number (A3, A4, A1, etc) then store B to get the same numbers, then store c, d, and e...

How in the world can i do this easily? If it was really on 5 stores and 10 numbers it'd be a breaze but it's 500 stores and 1500 numbers! Can i script this somehow? the final file has to be a text database with all of the generated numbers in their own record.

the way i have done it was create a text file of just the Number fields, have a script where i set the store number, then import the text file of numbers... basically i manually set the store number then import 1500 records, then go to the next store number, etc. The process / script runs extremely fast but it's a lot a human interaction and it takes forever, plus i dont want to accidently miss a store.

[Fitch]

Off the top of my head, you could:

- import col.1 into file A and col. 2 into file B

- make a new file C

- make a script in C that creates a new record and set a field to a global from file B

- make a script in B that loops through all records, setting the global to globalA & number, then calling the script in C above

- make a script in A that loops through all records, setting globalA to the store, then calling the loop script in B above

Got it?