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.

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