rkellow
asked on
Reading a delimited text file into SQL Server table
Hello,
I'm trying to find the best way to read a pipe delimited flat file into a SQL Server table.
Thank you.
I'm trying to find the best way to read a pipe delimited flat file into a SQL Server table.
Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Try :
https://www.experts-exchange.com/questions/21039477/Importing-data-from-a-flat-file-into-SQL-Server-DB-using-BCP-utility.html?sfQueryTermInfo=1+bcp+bulk+insert+server+sql+util
and or
https://www.experts-exchange.com/questions/22144383/BCP-Import-Export.html?sfQueryTermInfo=1+bcp+bulk+insert+server+sql+util
https://www.experts-exchange.com/questions/21039477/Importing-data-from-a-flat-file-into-SQL-Server-DB-using-BCP-utility.html?sfQueryTermInfo=1+bcp+bulk+insert+server+sql+util
and or
https://www.experts-exchange.com/questions/22144383/BCP-Import-Export.html?sfQueryTermInfo=1+bcp+bulk+insert+server+sql+util
ASKER
Thank you. I neglected to say that I need to select only certain fields from the text file and it seems as the B) answer will work best. I will be getting this text file every day and need to add rows to the SQL table but only certain fields. I have another SQL question pertaining to this but I will open a new question for it.
Thank you again,
r
Thank you again,
r
If not, then you can use either BCP or OPENROWSET to insert records from the flat file..