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
jackparsana
0
Junior Poster in Training
Recommended Answers
Jump to PostNormally 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.
…
All 3 Replies
drjohn
56
Posting Pro in Training
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.
fobos
19
Posting Whiz in Training
Use Navicat for MySQL
Bruce100
0
Newbie Poster
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.
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.