Import from Excel with exact fields

  • Thread starter Thread starter Pete
  • Start date Start date
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
 
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/
 
Back
Top