I have a few clients that use the same point-of-sale retail system. This
system produces extracts in the form of Excel spreadsheets. Unfortunately,
one of the extracts that has the most valueable data on it contains rows in a
hierarchical format similar to the following:

DATE RECEIPT# CUSTOMER TOTAL_SALE
ITEM# QTY PRICE

5/1/05 2956 Jones, S. $58.00
123 2 $7.00
456 1 $44.00

How can I go about efficiently importing this data into a SQL database
(hopefully with DTS) into an order/order_details fashioned arrangement?

--
Message posted via http://www.sqlmonster.com