Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
1
Answer
Extracting data from SQL 2005 to Excel: numbers issue
Ask a question
Ask a question
Upload Source Code:
Select only zip and rar file.
Dario Barbon
8y
305
1
Reply
Hi all!
In my production VB6 application, I use the following query to extract data to Excel.
INSERT
INTO
OPENROWSET
(
'Microsoft.Jet.OLEDB.4.0'
,
'Excel 8.0;Database= E:\myfile.xls;'
,
'SELECT * FROM [Sheet1$]'
)
SELECT
*
FROM
myTable
This query works fine but in my Excel file all numbers are presented as text values despite all columns type are correctly defined
Why? Is it a driver issue?
The server is SQL 2005 SP4 Workgroup Edition.
Thanks.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
Convert group_concat of MYSQL to SQL query
Create Web API For Login Form in c# asp.net