Re: Column headers for exported data

I thought about a record that contains the field names. My observation,
though, is that the numeric fields do not export alphanumeric
descriptions entered in them.

In other words, if I have a field called temperature og "number" type,
and if I enter in a special record "Temp" to make it into a header when
exporting, I end up getting a blank in the export.

Perhaps there is a way around this?

Sam

.

Relevant Pages

  • Setting EXCEL columns data type
    ... I am exporting data from ACCESS database to EXCEL. ... There are numeric fields in the query but after exporting, ... How do I change the data type of the EXCEL columns before exporting. ...
    (microsoft.public.access.modulesdaovba)
  • RE: How to compare fields
    ... > I need to compare three numeric fields and pick the greater of the three; ... > will then have to use that number in subsequent calculations. ... Prev by Date: ...
    (microsoft.public.access.queries)
  • How to return the max value from expression-list?
    ... In an Access 2003 SQL Select-query, I want to put the max of a list of ... numeric fields from each table row into a new variable, ... but now errs as having the wrong number of arguments. ... Prev by Date: ...
    (microsoft.public.access.queries)
  • RE: Default Value from last record in table
    ... By the way, my field is CURRENCY. ... I found here a solution for TEXT and COMBO BOX but not for numeric fields ... > Does anyone have a better suggestion? ... Prev by Date: ...
    (microsoft.public.access.forms)
  • Re: counting records
    ... > I have a table with one numeric fields. ... > i want to add a record number field in a query ... Hi Pierre, ... Prev by Date: ...
    (microsoft.public.access.queries)