Urgent : Exporting Access 97 data to Excel 97
in excel, select the column that you want to keep the leading 0's in
and go to Format->Cells, Under the Number tab choose Custom, in the
Type field go something like:
00000000
.... to have a field that will keep the leading 0's and be 8
characters long.
r
Quote:
> >-----Original Message-----
> >Erik wrote
> >> Hi -
> >> I'm having a few problems generating Excel 97 reports
> with
> >> Access 97. First of all, it reads certain fields as
> >> Numeric that should be read as Text or General (for
> >> instance, with Id numbers that begin with leading
> zeroes,
> >> the zeroes are cut off.)
> >Try using transferText to a CSV along with an export
> specification (see
> >Help).
> >> Second of all, the Excel file
> >> winds up being in Excel 95 format!!
> >For that, you'll need to use TransferSpreadSheet with
> >acSpreadsheetTypeExcel8.
> >Seems like you're better off automating Excel for this
> feature.
> > -- Dev
> >.
> Thanks for the help. I guess I'll have to format the Excel
> file after the export and do "Save As." I think it would
> be easier just to import the file into Excel instead of
> fooling with the Access part, but it's not really up to
> me :(
