AnsweredAssumed Answered

Import Excel Auto Import Customer Name to Transaction lines

Question asked by puzzledata on Oct 13, 2009
Latest reply on Oct 21, 2009 by philmodjunk

Title

Import Excel Auto Import Customer Name to Transaction lines

Post

The spreadsheet of data I am importing into my database, has the Customer information in one line, and all the transactions on the lines that follow.

I need to have the CustomerNumber present in each transaction line, however there is nothing unique to the customer name or number in the transaction lines.

there is a Customer Info line that preceeds all the transactions. I need to capture that CustomerNumber and include it with each transaction line that follows until a new CustomerInfo line appears to indicate the next customer. 

 

CUSTOMER 1    ADDRESS   CITY STATE ZIP (this is an example of a CustomerInfo Line)

                           1ST TRANSACTION DOLLAR AMOUNT (This is an example of TransactionLine)

                           2ND TRANSACTION DOLLAR AMOUNT

 

CUSTOMER 2   ADDRESS   CITY STATE ZIP

                           1ST TRANSACTION       DOLLAR AMOUNT

                  2ND TRANSACTION      DOLLAR AMOUNT

            3RD TRANSACTION      DOLLAR AMOUNT

 

Please help as I am very stuck with this project until I get beyond this point.

Outcomes