Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
exporting data from access to excel
When I try to export data from an access table to excel one column
gets converted into date format even though it is in text format in access. The column contains forward slash as part of its data. can anything be done to prevent the data being converted into date. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
exporting data from access to excel
If you are bringing the file in as .csv (auto-recognised) you could change to setting the format of the column to Text prior to import, then Data, Import External Data, Import Data and walk through the wizard, make sure the column retains it's Text form. Hope this helps. -- Wrote: When I try to export data from an access table to excel one column gets converted into date format even though it is in text format in access. The column contains forward slash as part of its data. can anything be done to prevent the data being converted into date. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=531815 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Large Access Table into Excel | Links and Linking in Excel | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Data Access Pages - Excel 2003 | Excel Discussion (Misc queries) | |||
New Excel data does not appear in linked Access table | Excel Discussion (Misc queries) | |||
Fetching External Data from Excel | Excel Discussion (Misc queries) |