Export Access Data to Excel but format is terrible.

**hardhitter06** · 11-20-2009, 04:43 PM

Hi All,

Access and Excel 2003.

Is there a way by any chance to export data from Access to Excel, to a specific template that formats the fields better?

I know how to export data to excel, but the Time field comes up as "00-JAn-00" for all records. Also, some of the State and Research accounts aren't show because the column isnt wide enough and I have to fix that to see all of the data. There is also a couple other small format issues.

So I'm wondering if its possible to set something up like that for excel to eliminate these formatting issues because I need export to excel on a daily basis??

Thank you in advance

**ConneXionLost** · 11-20-2009, 06:37 PM

Hi hardhitter06,

How about setting up two sheets in Excel, one for receiving the import from Access, and the second reads the first sheet (with A1=AccessImport!A1), but holds all your formatting.

Cheers,

**Mikeopolo** · 11-23-2009, 12:31 AM

If you used MS Query to query the Access database, I think you could format the query range and then just refresh it on future occasions.

Regards
Mike