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?
Any way to do this?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.