Import from Excel with exact fields

P

Pete

Are you talking Access or Excel? If its Acces you're
having troubles with, you should define the field as text
if there is a possibility that there will be anything
other than whole numbers. If it's Excel, it shouldn't
matter, but if it does; use the same principal.
gl, Pete
 
M

masterjojobinks

The best way to force a specific field type for the table is to mak
sure the first cell in excel has data of the datatype you want th
access field to be. IE. if you want the field to be numerical the
make sure the first cell in that column is a number
 
J

Jeff Boyce

Another approach is to simply import the Excel data into a temporary table
in Access, then create a "permanent" table in Access that has the exact data
types you need. You can use a query to append records from the temporary to
the permanent table.

This also gives you the opportunity to "parse" the data into a more
normalized table structure in Access, since it would be unusual to have
tables in Excel that were already well-normalized.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
 
Top