Al Black
unread,Jul 5, 2011, 9:18:19 AM7/5/11Sign in to reply to author
Sign in to forward
You do not have permission to delete messages in this group
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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?