Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
linking access to excel
i am trying to link an access table into excel by using the Menu item:
Data--get external data-- new database query. My problem is that i keep getting the error "[Microsoft][ODBC Microsoft Access Driver]invalid datetime format on column number 1 (date/time). My date/time should come in like the table has it, 12/2/2005 15:45, but it will not go through with the query. i have tried it with the date time separated into different columns and it will work, and it will show 12/2/2005 0:00 for the date column and a wrong date in front of all of the times. Regaurdless, I need them grouped together, but just wanted to see if it worked the other way. Can anyone help with this or know why this is happening? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking parameter query from Access to pivot table in Excel | Excel Discussion (Misc queries) | |||
Access Excel Linked Text and Number Issues | Excel Discussion (Misc queries) | |||
Send Excel data to Access through button | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Refreshing Access data in Excel | Excel Discussion (Misc queries) |