SQL Server Script
- or -
Post a project like this$$
- Posted:
- Proposals: 1
- Remote
- #36355
- Expired
Description
Experience Level: Intermediate
We have 50 CSV files containing from 3,000 to 50,000 records each with approximately 45 fields per record - all fields and layouts are consistent. total of around 500,000 records.
We need a SQL server script that will work through each of the files in a specified folder, open each, read each and then write the contents of each to a single \'flat\' table with the exact record field layout.
attached csv is sample data and record field layout.
from time to time the data in the csv files is updated so we need to be able to handle this as a batch job without manually modifying the csv files.
We need a SQL server script that will work through each of the files in a specified folder, open each, read each and then write the contents of each to a single \'flat\' table with the exact record field layout.
attached csv is sample data and record field layout.
from time to time the data in the csv files is updated so we need to be able to handle this as a batch job without manually modifying the csv files.
James B.
0% (0)Projects Completed
-
Freelancers worked with
-
Projects awarded
0%
Last project
26 Apr 2024
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies