Automate Merge of daily .csv files on Internet into Single Access Table
$100-500 USD
クローズ
投稿日: 19年近く前
$100-500 USD
完了時にお支払い
Need a Macro to automate merging of daily price data in .csv files available on internet into a single Access Database Table.
See
<[login to view URL]>
Individual .csv files are posted in monthly compressed .zip files. We need get data from the individual files into a single annual access database (too big for excel).
There are several different types of files. I would like the user to be able to specify the name of the file and have the macro import each day's data for that file type. examples are
Day-Ahead Market LBMP - Zonal
[login to view URL]
[login to view URL]
[login to view URL]
.etc
files for 12/1/2004-12/31/2004 are located in the .zip file
[login to view URL]
Real-Time Market LBMP - Hub Prices
[login to view URL]
files for 12/1/2004-12/31/2004 are located in [login to view URL]
Real-Time Market LBMP - Zonal
[login to view URL]
files for 12/1/2004-12/31/2004 are located in [login to view URL]
All the datafiles will be downloaded into a single folder. The VB macro needs to open the correct folder and file and put data into a single table. I would like to have two options 1) import all the data into a single Access Database, 2) import just the LBMP data (Column D) into an Excel worksheet with dates and locations down the first columns and hours across the first row (perhaps the user should be able to specify the column with the desired data).
Examples of the input .csv files and what I would like the output to look like are attached.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
well documented VBA code that can be edited and modified.
Good debugging and error traping
## Platform
Microsoft Office for Windows XP, either in Excel or Access VBA.
Need a file I can open in Access or Excel and then run the macro.