ADO.NET Excel Connections & DataType INT32

  • Thread starter Thread starter Phil Williams
  • Start date Start date
P

Phil Williams

Hello,
Can anybody tell me if it is possible to create a Table with an INT32 field
with a ADO.NET Excel type connection?
I have done this sucessfully with VARCHAR types but when I create an INT32
field and populate it it becomes a string value. ie In Excel it has looks
like '32.
This means that when working with pivot tables Excel starts complaining.

Any help on this would be GREAT!
Cheers
Phil
 
¤ Hello,
¤ Can anybody tell me if it is possible to create a Table with an INT32 field
¤ with a ADO.NET Excel type connection?
¤ I have done this sucessfully with VARCHAR types but when I create an INT32
¤ field and populate it it becomes a string value. ie In Excel it has looks
¤ like '32.
¤ This means that when working with pivot tables Excel starts complaining.
¤

How are you creating the Excel Worksheet (Table)?


Paul
~~~~
Microsoft MVP (Visual Basic)
 
Sorry my fault,
It does work after all. When I went back over my code I was creating the
fields as VARCHAR .

Phil
 
Back
Top