Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
NDC NDC is offline
external usenet poster
 
Posts: 3
Default Access autonumber field changes to date format when Excel imports

When importing Access data into Excel, the autonumber field in Access is
chenged to date format instead of a general number format. I could run a
macro to change the number format but this only happens on some Vista
machines, not all.

Any suggestions as to why this is happening?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Analyze with excel (change access date format) Driftwood Excel Worksheet Functions 4 June 9th 09 02:15 PM
Excel Access Imports Tom J Excel Discussion (Misc queries) 4 May 9th 08 07:26 PM
Access form in Excel Autonumber Mald Excel Discussion (Misc queries) 0 August 24th 06 02:09 PM
Date Format Issues Access to Excel RC Excel Discussion (Misc queries) 3 June 13th 06 11:28 AM
in vba for access how do i get the day of the week for a date field? Daniel Excel Worksheet Functions 1 July 8th 05 12:57 AM


All times are GMT +1. The time now is 02:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"