| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
OLEDB Error reading Header Name ("State")
Hi,
I am using Jet.OleDb.4.0 and using OLEDB reader to read csv file using DataReader. If the column name in CSV file is STATE then DataReader.GetName (index) returns FileName#.csv.State. It works fine with excel and all other names are fine with CSV. If I change the column header to Stat then everything works fine. How could i resolve this issue without changing the header name in excel file Thanks, PP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting "State" Column onto separate worksheets in same workbook. | Excel Worksheet Functions | |||
| Listbox header inside VBA (Array("Head1", "Head2", ...) | Excel Programming | |||
| What is Error "Method "Paste" of object "_Worksheet" failed? | Excel Programming | |||
| Is there a diferent "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" | Excel Programming | |||
| reading variable "from" and "to" ZIP codes | Excel Programming | |||
Linear Mode
