Member Avatar for jackparsana

HI,

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.

jack

Edited by jackparsana because: By mistake version chage
  • 4 Contributors
  • 3 Replies
  • 238 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by Bruce100
Member Avatar for drjohn

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.

Member Avatar for fobos

Use Navicat for MySQL

Member Avatar for Bruce100

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, networking, learning, and sharing knowledge.