question

abhitrivedi64 avatar image
abhitrivedi64 asked

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.
sqlcsv
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Oleg avatar image Oleg commented ·
@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.
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.