Access Export to csv or tab Delimited.
Posted on 2015-02-11
How can i get access to export data so that when opened in excel the data of a field looks like the data that was in an access memo record.
For Example, the below text is what is saved in a record in access. The export has several columns this is just one field. I need to be able to export out the data so when opened in excel as a txt or csv file the data below stays in one field and one record. This is because this data is being imported in QuickBooks and needs to stay in one record.
Found angle stop leaking won't turn off
Found tank to bowl leaking
Found closet ring rusted out. Causing wax ring to fell. Leaking
Found major discoloration on ceiling at entry way.
Found ball valve in garage will not turn off water to house
Installed new angle stop
Installed new supply line
Replaced tank to bowl gasket
This job is not complete. This job is not complete
we are submitting a proposal for remediation and buildback.