Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a header to a CSV file
Hi,
I have a number of CSV files I wish to query using ADO, the only problem is there are no headers in the CSV files. The obvious option is to open them in excel and manually enter the headers, howerver there are more than 65536 records so this is not possible. Does anyone have any good ideas? any help would be much appreciated. Thanks, Tom |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a header to a CSV file
If it only a few files that you need to change, NotePad/WordPad can open
these Otherwise, you can import them into Access. Number of rows is not a concern then. Make you changes then export, if you need to keep the .csv format. NickHK "Tom Cameron" wrote in message ups.com... Hi, I have a number of CSV files I wish to query using ADO, the only problem is there are no headers in the CSV files. The obvious option is to open them in excel and manually enter the headers, howerver there are more than 65536 records so this is not possible. Does anyone have any good ideas? any help would be much appreciated. Thanks, Tom |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a header to a CSV file
If you know what the headers should be then you could just construct your SQL using the default field names provided by ADO and
alias the names to the "correct" values... Tim "Tom Cameron" wrote in message ups.com... Hi, I have a number of CSV files I wish to query using ADO, the only problem is there are no headers in the CSV files. The obvious option is to open them in excel and manually enter the headers, howerver there are more than 65536 records so this is not possible. Does anyone have any good ideas? any help would be much appreciated. Thanks, Tom |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a header to a CSV file
Do they all use the same layout?
If yes, create a file with that single header line. Then shell to DOS and merge the files using an old DOS command. Go to the folder that contains the .CSV files and header file and issue this command: copy Header.txt + somefile.csv somefileNEW.csv Tom Cameron wrote: Hi, I have a number of CSV files I wish to query using ADO, the only problem is there are no headers in the CSV files. The obvious option is to open them in excel and manually enter the headers, howerver there are more than 65536 records so this is not possible. Does anyone have any good ideas? any help would be much appreciated. Thanks, Tom -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a header to a CSV file
Thanks for you help everyone, I've used the default ADO headers to get
this to work. Cheers, Tom Dave Peterson wrote: Do they all use the same layout? If yes, create a file with that single header line. Then shell to DOS and merge the files using an old DOS command. Go to the folder that contains the .CSV files and header file and issue this command: copy Header.txt + somefile.csv somefileNEW.csv Tom Cameron wrote: Hi, I have a number of CSV files I wish to query using ADO, the only problem is there are no headers in the CSV files. The obvious option is to open them in excel and manually enter the headers, howerver there are more than 65536 records so this is not possible. Does anyone have any good ideas? any help would be much appreciated. Thanks, Tom -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding a formula to the header | Excel Discussion (Misc queries) | |||
adding cell reference on a header | Excel Worksheet Functions | |||
email header on a file | Excel Discussion (Misc queries) | |||
Please help with Adding a Footer or Header | Excel Discussion (Misc queries) | |||
Adding Header to multicolumn ListBox | Excel Programming |