|
-
Apr 9th, 2010, 10:46 AM
#8
Thread Starter
Hyperactive Member
Re: Importing CSV to SQL
 Originally Posted by techgnome
That's why you dump it into a staging table first.... with out the Unique ID... then when you do your INSERT/SELECT query, you can take that into consideration. It's a common practice.
-tg
TG & Jmic,
Could either of you tell me how to assign the values from the CSV to the SQL table? I think I am going to build the program both ways (I could use the practice).
The SQL server is on this LAN, so I want to see how fast it would be looping through the records. (This was the idea in the original post.) Any ideas on how to do this?
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote