Showing posts with label sap. Show all posts
Showing posts with label sap. Show all posts

Friday, March 9, 2012

Importing Data into SQL 2005 Express

I am getting a dump of information from SAP into an Excel file. I would like to take this excel file and import the data into a SQL 2005 Express database.

Is this possible? Or will I need the full version of SQL to do this?

Thanks

Hey IronSights,
If you save the excel file in csv format, you could then use BULK INSERT to import the data.|||Thank You, I will give that a shot.