Linked spreadsheet to table - type violations

  • Thread starter Thread starter Robin Chapple
  • Start date Start date
R

Robin Chapple

I have an Excel spreadsheet with five numerical columns.

I need to link it to an Access table. When I do that three fields
finish as numeric and two as text and subsequent operations within
Access report violations.

Where do I look for and answer to the problem
 
Robin

Access doesn't always understand the data types for Excel columns. This can
happen sometimes when the first few rows of data are one type (e.g., all are
numbers) and Access decides the field type is numeric, when both numbers and
letters are in the (Excel) column, but not until a few more rows down the
spreadsheet.

One solution is to create a table in Access that has the data types YOU know
are correct, then import into that table.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top