Tuesday, 1 October 2013

Import updating CSV into SQL Server

Import updating CSV into SQL Server

I'm looking for a simple solution (beginner to SQL) to allow the import of
data from my .csv file to my SQL DB.
I have a third party program that is updating my .csv file every 30
seconds and I want to put that updating information into my SQL DB. I
tried the importing & exporting wizard but it didn't work due to the .csv
file being utilized by the other third party program.
Getting the information into the SQL DB doesn't need to be in real time it
could just retrieve all the information when opening a saved sql query
file.
Thank you!

No comments:

Post a Comment