Paste Access data into Excel spreadsheet

J

JDM

I was recently upgraded from Office97 to Office2002 (XP, I believe). In the
past, if I copy and pasted Access data into an Excel spreadsheet, Excel was
able to determine if the individual fields were text or number or date. With
the upgrade, all fields are set as text when they are copied into Excel.
This presents a problem with formulas I have set-up in Excel that are looking
to calculate number fields. I have even tried to change the fields to number
fields, but this doesn't work and is a bit tedious, too Does anyone know how
I can get the process to work like it did with Office97?

Thanks!
 
J

Jim Rech

I'm not much of an Access user but I just opened the Orders table in the
Northwind database that comes with Office in Access 2003 and copy/pasted it
into Excel 2002 (and 2003) and all fields seemed to come in as they should.
Dates stayed dates, numbers numbers...

--
Jim
|I was recently upgraded from Office97 to Office2002 (XP, I believe). In
the
| past, if I copy and pasted Access data into an Excel spreadsheet, Excel
was
| able to determine if the individual fields were text or number or date.
With
| the upgrade, all fields are set as text when they are copied into Excel.
| This presents a problem with formulas I have set-up in Excel that are
looking
| to calculate number fields. I have even tried to change the fields to
number
| fields, but this doesn't work and is a bit tedious, too Does anyone know
how
| I can get the process to work like it did with Office97?
|
| Thanks!
 

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

Top