Copying query results to Excel

  • Thread starter Thread starter Mickey Hoover
  • Start date Start date
M

Mickey Hoover

When using Office XP I have run into the following problem that was not an
issue in Office 2000. When I copy the output of a query, which includes
numerical data in some fields, all of the fields are treated as text in
Excel. To convert the "numeric" fields to numeric in Excel I must highlight
each column and click Data - Text to Columns - Finish. Each column must be
done individually. Is there a solution so that Excel will recognize the
numeric data? Thanks
 
It may be more reliable / efficient(?) to export the data
using the query as the Source to an Excel file.

Try the Menu File / Export ...

HTH
Van T. Dinh
MVP (Access)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

text and numbers in linked excel spreadsheet 3
VBA- Excel Programming:- 0
Linked Excel Field formatting Problem 6
Mixed Data Import from Excel 2
Linking from Excel 2003 to Access 2003 3
Copying table data in Access to Excel 2
ADO with mixed data 2
Transfer from Excel question 2

Back
Top