Automated Import of csv into SQL Server 2008 Express

I have SQL Server 2008 installed. I generate a csv file everyday and I want this file to be imported into the a specific table in this database. I need for the data in the table to be overwritten by this import.

Any way to do this?
LVL 1
ralphcarter2008Asked:
Who is Participating?
 
reb73Connect With a Mentor Commented:
You can use BCP or the OPENDATASOURCE/OPENROWSET TSQL commands (using the Microsoft Jet 4.0 text driver to read this as a set based table) if the csv fles are available in a location that is accessible by the SQL Server Service..

See EE PAQ link below -

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_24098776.html?sfQueryTermInfo=1+10+csv+file+opendatasourc

 
0
 
jmoss111Commented:
Is the SQL table in the same format as the .csv? You can use a TRUNCATE TABLE and a BULK INSERT to push the file.
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.