Automatically importing data into SQL Server from CSV file

I want to import data from a CSV file into a SQL Server. I want something to run automatically, i.e. listening from a directory for a new CSV file and then importing that file once the directory has a new CSV file.

more ▼

asked Nov 14, 2017 at 08:25 AM in Default

avatar image


@abhitrivedi64 Does the data from different CSV file need to be imported into the same table in SQL Server database? If so then all CSV files need to have the same structure (headers). Please provide some details.

Nov 14, 2017 at 01:37 PM Oleg
(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Nov 14, 2017 at 08:25 AM

Seen: 22 times

Last Updated: Nov 14, 2017 at 01:37 PM

Copyright 2018 Redgate Software. Privacy Policy