Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using CREATE TABLE DDL on Excel creates two tables
Hello. I am using OLEDB 4.0 to create an excel file and store DataTable rows
into it. I am using CREATE TABLE [SheetName] ([Column1] longtext, [Column2] longtext.... DDL and then write data using INSERT INTO ... DDL. There are three strange things that i've encountered and will be glad to get help from anyone: 1. If I use as a table name expression with spaces, the name is changed to expression with underscore '_' symbol instead of spaces. 2. I can not set trailing '$' when creating a table, but when inserting data I have to use the name with traling '$' otherwise the exception is thrown. Moreover, if i get the scheme of the Excel file later I am getting TWO tables instead of one: a first with the name without '$' and another the same with trailing '$'. Nedless to say that visually Excel shows only a name without '$' 3. If I am trying to do same operations using OLEDB 12.0 (Office2007) I get invalid file. If anyone knows how I can overcome above issues, please write me a code. I am coding in C# but VB examples are as good as any other. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
template creates invoice - how to create summary worksheet? | Excel Discussion (Misc queries) | |||
Pivot table creates stacked column | Charts and Charting in Excel | |||
Pivot table creates blank table | Charts and Charting in Excel | |||
Creates table instead of exporting data | Excel Programming | |||
How to create a template that creates and saves as sequencial num. | Excel Programming |