transfer data from Excel to SQL Server
- by Jason
I have an Excel Spreadsheet that contains all my data that I need to put into an SQL Server database. I am fairly new o ASP.NET and have never had to export from Excel to SQL Server before.
My Excel spreadsheets looks like this
Trade Heading - ArtID - BusinessName - AdStyleCode - Address - Suburb
In SQL Server I have created a table named "Listings" which is in this format
intListingID - intCategoryID - BusinessName - ArtID - intAdCode -Address - Suburb
What would be the best way to export the data from Excel and then import it into SQLServer 2005.
Thanks...