October 7, 2008 at 4:15 am
I was trying to copy a table from work to home and what I did was to SCRIPT the table as CREATE TO and then SELECTED about 50,000 records from the table and saved it as .csv file. When I arrived home and tried to import the data in the newly created table (as per the create script), I encountered some trouble importing as I found out that there were fields that has the character that I was using as delimiter. I also encountered an issue with the NULL values to be inserted in a field having the INT data type.
My questions are...
1. Are there other ways wherein I could do the export / import more easily?
2. What's the best delimiter to use when exporting data?
3. What's the best way to work with NULL data if you have an INT field in the table?
Thanks!
October 7, 2008 at 5:55 am
jpim3nt3l (10/7/2008)
1. Are there other ways wherein I could do the export / import more easily?2. What's the best delimiter to use when exporting data?
3. What's the best way to work with NULL data if you have an INT field in the table?
1. there are scripts available to create INSERTs for each record. Look for "Procedure to script your data" on http://vyaskn.tripod.com/code.htm
2. It all depends on your data. Just choose a character that doesn't exists in your values (; is often used)
3. Allow NULL in the field of the table you created (and make sure the value NULL in your .csv is without quotes or anything)
October 7, 2008 at 11:52 am
Thank you!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply