ADO.NET Excel Connections & DataType INT32

28 Mar 2006 6:12 AM

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

28 Mar 2006 3:15 PM

Paul Clement

On Tue, 28 Mar 2006 18:12:43 +1200, "Phil Williams" <Phillandsa***@hotmail.com> wrote:

¤ 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)

29 Mar 2006 2:06 AM

Phil Williams

Sorry my fault,
It does work after all. When I went back over my code I was creating the
fields as VARCHAR .

Phil

Show quote

"Paul Clement" <UseAdddressAtEndofMess***@swspectrum.com> wrote in message
news:mmki22doii3qnl6f0jbmlph7pjnhq45m07@4ax.com...
> On Tue, 28 Mar 2006 18:12:43 +1200, "Phil Williams"
> <Phillandsa***@hotmail.com> wrote:
>
> ¤ 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)