pls help me in this..

How to import Excel Sheet data into SQL Server 2008.?

i use
Excel 2010.
SQL Server 2008.

how to import data?

thanks in advance.


Recommended Answers

All 3 Replies

Normally you would export the data from your spreadsheet first. Most people say use a csv file, but as your data can easily include a comma in a text field, this is not the best format. Use tab delimited text instead, available as a file type option in Excel.

Then you have to either use some database management program to connect to your server and use the load data in file command to import the data. At least that's what I do every week with MySQL.

But Google will probably help you if there is a different method for SQL Server.

Use Navicat for MySQL

These are the general help forums that i need to learn more things that the topic is all about the import and the export of the data. I actually need to learn it.

Resume Writing Service

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.