exporting data from access to excel

  • Thread starter Thread starter vinayak.mahadevan
  • Start date Start date
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.
 
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.

--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Best third-party tool to repair OST files 1
Columns formatted As Dates Are Exported as a Number to Text 1
Exporting Data From Excel to SQL 1
CSV->Excel Data Problem 1
text to date when exporting from access to excel 3
Export Access to Excel text field with numbers 1
Sharing data between Excel and Access 2

Back
Top