Export - Fields format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to select how colums are exported to excel. I have about 30
Fields,
the first 10 are text and the last 20 are numbers.
When i export all of the fields do so as text. I then get the smart tab
error telling me that the cell value is a number stored as text. I have a
40,000 lines so when i try to convert them all to numbers, it takes a long
time. I feel like there is a way to avoid this step but do not know how.
 
Instead of exporting a table, export a query based on the table. You might
need something like the CDbl or CLng functions to explicitly force the data
to be numbers.
 
Back
Top