1.2 million inserts trough odbc

What is the fastest way to insert 1.2 million records using odbc.

dbf -> Change values -> mssql

dgbAsked:
Who is Participating?
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
<<Is there no way to do it using odbc>>Yes there are ways but they are not the fastest...If you want ot do this through VB, you may consider calling the BULK INSERT statement in TSQL from VB using ODBC or any provider (better use other provider, ODBC is underoptimized for this kind of operation)...

Check this link for usage

http://www.transactsql.com/html/BULK%20INSERT.html

Hope this helps...
0
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
Use DTS import wizard...
0
 
dgbAuthor Commented:
I can't the "change values" is something i have to do in vb
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
LowfatspreadCommented:
>"change values"

what is the process that you're trying to achieve...?

what proportion of the database/table does the 1.2m rows consume?
are you afffecting indexes with your changes?
are you changing foreign keys?

0
 
dgbAuthor Commented:
Dont know what you mean by this.
>>what proportion of the database/table does the 1.2m rows consume?

I removed all the foreign keys and the only index is the unique key

What i change is not that important, i just want to insert 1 million records using odbc.
Is there a quick way to go about this, maybe changing some settings.
Locking the database or . . .

0
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
<<I can't the "change values" is something i have to do in vb>>Then you can build a package in DTS designer wichi allows to run TSQL and VB scripting in undifferiated manner...(even though TSQL is more efficient)
0
 
dgbAuthor Commented:
Is there no way to do it using odbc
0
 
dgbAuthor Commented:
will check it out thanks for now
0
 
YZlatCommented:
This question has been classified as abandoned as it has no comments in the last 21 days.  I will make a recommendation to the moderators on its resolution in approximately 4 days.  I would appreciate any comments by the experts that would help me in making a recommendation.

It is assumed that any participant not responding to this request is no longer interested in its final disposition.

If the asker does not know how to close the question, the options are here:
http://www.experts-exchange.com/help.jsp#hs5

YZlat
EE Cleanup Volunteer
0
 
dgbAuthor Commented:
Racimo :
Thanks.
i still have not had the time to look into it but thats my problem.

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.