Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ckrishna
Starting Member
2 Posts |
 Posted - 2012-08-15 : 15:35:12
|
| Hi all, I'm new to MySQL. I'd like to add data from an Excel spreadsheet to a table I've made in a MySQL database. The spreadsheet is saved as a CSV, so I did the following:bulk insert minipivot from 'C:\\Users\\Chirag Krishna\\Desktop\\PivotTable\\Test.csv' with (fieldterminator = ',' , rowterminator = '\n')"However, I always get a syntax error message. Any ideas as to what might be wrong with this? I've checked out some of the other threads on this issue but couldn't find what I was looking for...it's probably just some small thing that I'm forgetting. Thanks for your help! |
|
|
ckrishna
Starting Member
2 Posts |
Posted - 2012-08-15 : 15:37:05
|
| Apologies- minipivot is the table in the database, and I did remember to add the semicolon at the end. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2012-08-16 : 07:37:29
|
| What was the error message?MadhivananFailing to plan is Planning to fail |
|
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-08-16 : 07:49:54
|
| Also, this forum specializes in Microsoft SQL Server. For MySQL questions, you may get faster and better responses at dbforums.com. Post the question AND the error message though. |
|
|
|
|
|
|
Problem with Excel CSV Bulk Insert