Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Removing apostrohies from exported excel cells

Avatar of ccowan159
ccowan159Flag for United States of America asked on
Microsoft Access
3 Comments1 Solution316 ViewsLast Modified:
I have a database that I need to export to excel. I have tried it to ways.

(1) I run a report and then click on my custon toolbar and it spits the headers with associated data to excel

(2) The other is using this command.

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qrySetoff", "C:\Setoff.xls"

When I use #1 some of the date fileds that have leading zeros are gone when it's exported.

If I use #2 it's perfect except that every field has an apostrophy at the beginning of each field.

I need the leading zeros and I want to make it easy for users to run the export as needed.

Can you tell me how to remove the apostrophies or add the zeros back in #1.

Thanks

Chris C