Everytime I export to Excel, or even when I copy and paste into Excel, all of the fields come in as text. If I have a numeric field in Access, it comes into Excel in a general or text format. On my other computer, everything works normally, Excel recognized date and numeric and currency formatting. Is there a setting to correct this?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Copy/Export from Access 2002 to Excel 2000
- Thread starter mcgettge
- Start date
Similar threads
- Locked
- Question
- Locked
- Question