Docmd.TransferSpreadsheet imports text fields in wrong format

S

sJ

I am importing an Excel file into Access using Docmd.Transfer spreadsheet.

One of my fields in Access is set up as text. The data in Excel for this
column is formatted as text.
However, some are Numeric in Excel formatted as text and others are text in
excel.

For example

ST5000 <------ Imports correctly
5337098 <-------- Displays as 1.10011e+006 or something similar in access

Is it possible to format this in access? the data is displaying, but in the
wrong number format.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Address Format changed after Migration 0
How to Import Formatted text as new Slides in PowerPoint 0
Formating bolded text exclusively. 0
Problem with MS Word paragraph and character styles: format getting messed up 2
Autonumber field in Excel that behaves the same as Access 0
exporting report fields to spreadsheet 1
Word macro that can call cells out of Excel for a find and replace 0

Top