Importing data from a single excel sheet

By archana_motagi ·
I have an Excel sheet,sheet1 in which First row is termed as Reimbursibles. Under this there are 10 rows.I.e its remursible data.

Then after keeping one row blank I have invoice data. Under this i have 12 rows. ie this is invoice dtaa.
I want to import reimbursible data in one SQL server 2005 table and Invoice data in another table.

I am able import excel sheet data using Sqlbulkcopy in the web application. But this will import data from the whole sheet into one table.
As explained I need to import two sets of data into two different table.
Please help.
Thanks in Advance.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Save As

by ThumbsUp2 In reply to Importing data from a sin ...

Save the whole sheet as a CSV (DOS) two different times (two file names). Then, using Notepad, open each file and delete the unwanted data from them. Then, import the resulting CSV files into the appropriate tables.

Related Discussions

Related Forums