Link to home
Start Free TrialLog in
Avatar of ralphcarter2008
ralphcarter2008

asked on

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?
Avatar of jmoss111
jmoss111
Flag of United States of America image

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.
ASKER CERTIFIED SOLUTION
Avatar of reb73
reb73
Flag of Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial