Import from Excel

G

Guest

I've been running a Macro that Imports from Excel. After the Import runs one
of my field data types is changing from text to number and I'm losing data.
My Import Spec, Table, and the Excel File all have text data types before the
Import but after my table is a number. Any thought on how I can fix this?
 
G

Guest

Add a dummy record to the Excel file for the first record with the correct
data types. You can delete that record after the import
or
Import into an existing table with the correct filed types
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
import excel data - scientific notation 1
Import errors from Excel 3
Importing Excel file into Access -- format errors 7
Import Errors table? 1
Import files into access 1
Import Excel 2010 table into Access 2010 - not listed as range 1
Import 4 Different Excel Files from One Folder 0

Top