Networks

Ask something
Question Locked

Importing data from a single excel sheet

0 helpful
2 replies

by archana_motagi

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

2 replies

by thumbsup2

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.

This discussion is closed to new replies.