D DaveF Nov 28, 2004 #1 I need to import a LARGE csv file. I need a fast way to do this??? -- David Helixpoint LLC. http://www.helixpoint.com
I need to import a LARGE csv file. I need a fast way to do this??? -- David Helixpoint LLC. http://www.helixpoint.com
S Scott Allen Nov 28, 2004 #2 It depends on what you are going to do with the data. If you need to put it into a SQL Server table, I'd use DTS to import and fastload the data without the overhead of a transaction. If you need to keep the data around in memory, use StreamReader and String.Split to bring the data in and crack apart the fields. There are a plethora of options, not sure which one is the best fit for your application, though.
It depends on what you are going to do with the data. If you need to put it into a SQL Server table, I'd use DTS to import and fastload the data without the overhead of a transaction. If you need to keep the data around in memory, use StreamReader and String.Split to bring the data in and crack apart the fields. There are a plethora of options, not sure which one is the best fit for your application, though.
K Ken Cox [Microsoft MVP] Nov 28, 2004 #3 Probably the fastest is the ODBC Driver for Text : http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm#ODBCDriverForText
Probably the fastest is the ODBC Driver for Text : http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm#ODBCDriverForText
