Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
exporting worksheet to access
Hello:
I'm looking for help with a specific problem in exporting an Excel table into Access. I was able to do this successfully (for the most part), but hit one major glitch. One of the columns in the original table contains dates. When that column landed in Access, the dates were transformed into numbers that have no apparent relation to dates (i.e. simply going in and changing the format of the column to "Date/Time" didn't help). Instead of being a date w/in the past 10 years or so, there are numbers such as 38945 and 36859. I went back to Excel and changed the format of the column to perfectly match the format that I wanted it to be in Access, but this didn't help. Any ideas? Thanks very much- Judy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I restrict access to only one worksheet in excel? | Excel Discussion (Misc queries) | |||
Exporting an Excel Chart into Access | Charts and Charting in Excel | |||
I copied a workbook to a CD. I can only access 1 worksheet. | Excel Discussion (Misc queries) | |||
Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
exporting excel worksheet to word | Links and Linking in Excel |