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.
No comments:
Post a Comment