exporting data from access to excel

V

vinayak.mahadevan

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.
 
B

Bryan Hessey

If you are bringing the file in as .csv (auto-recognised) you coul
change to setting the format of the column to Text prior to import
then Data, Import External Data, Import Data and walk through th
wizard, make sure the column retains it's Text form.

Hope this helps.

--
 
Top