Importing from CSV with AutoIncrement ID

139 views
Skip to first unread message

Al Black

unread,
Jul 5, 2011, 9:18:19 AM7/5/11
to SQL Buddy
I've created a table and all is OK. I've exported the table as a CSV
so I can use that as the template to import data back in, but it
always says x rows has been skipped. The exported blank CSV is of
format:

"AutoId","name","distance","shortName","year","date"

My CSV is of format:

AutoId,name,distance,shortName,year,date
,North Downs Way 26.2 2011,26.2,NDW26.2,2011,
,North Downs Way 50 2011,50,NDW50,2011,
,North Downs Way 100 2011,100,NDW100,2011,
,Thames Path 100 2012,100,TP100,2012,

So there's the quotation marks are a difference. How can I import
without the quotation marks?
Reply all
Reply to author
Forward
0 new messages