By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,705 Members | 1,301 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,705 IT Pros & Developers. It's quick & easy.

Export dataset to Excel setting Excel cell type.

P: n/a
I have an application that is trying to export multiple datasets to and
excel workbook in different worksheets. I have gotten the export to
work except for string fields that happen to be numbers being converted
to a number field. For example one value in a string field is "0008"
and when I export into excel it turns into 8.

I know when I manually import a csv file into excel I have to option to
say what type of field a specific column will be in excel like dates,
text and number fields.

Anyone know how to specifically set the what kind of data is going to
be in the excel column?

This is a windows application and I am using VB.net and SQL.

Sep 15 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.