How to insert data saved in Excel file on Clientside into database on Serverside

[Eric W]

Hi, How can i insert data saved in Excel file on Clientside into database on Serverside. thanks,

[GuyThiebaut]

In Enterprise Manager select: Tools, Data Transformation Services, Import Data... The wizard will guide you through the import. Regards Guy

You always pass failure on the way to success.

[Eric W]

Thanks for your reply! But my meaning is how to implement it in program based on B/S arch.

[GuyThiebaut]

You could create a DTS package to read the excel file into a table. The package could then be run from a job or stored procedure each time data from the spreadsheet needed to be imported.

Eric.W wrote:

B/S arch

Can you explain to me what this is please? Regards Guy

You always pass failure on the way to success.

[Eric W]

thank you again ,you are very nice. its meaning is browser/server architecture.