Re: Urgent: Exporting Access into Excel

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi Matt,

Hopefully you've worked it out now, as this was urgent but in case not, try
this:-

DoCmd.TransferSpread*** acExport, 8, "XXX", "YYY", True

where XXX is your table name, and YYY is the name (including the full path)
of the Exel file you want it saved to. The only problem I have found is that
sometimes the coversion process changes numbers in text fields (like phone
numbwers) to actual numbers in Excel, so 01293 765123 becomes 293765123.

The True at the end means that the field names go as well. If you don't need
them, then substitute false.

mattylance@xxxxxxxxxxx wrote:
>Hello, I need help exporting or linking MS Access queries into Excel
>spreadsheets. This will be a daily task. Is there any way of doing
>this? I tried using the transferspread*** macro but couldn't figure
>it out. Any adivce is appreciated!
>
>Thanks
>Matt
.

Quantcast