Hard Time Importing Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm having a hard time importing information from Excel to Access.

The Fields are LastName, FirstName, SSN (last 4 digits), HireDate, Two
Yes/No fields

I don't know what is causing the errors. I eliminated the Yes/No fields
think they may be the source of the problem and I changed the Date to text
and i still have problems.

I don't know what else to do. I've been spending hours on this stupid little
problem holding me up.
 
It would be easier to make useful suggestions if you told us what's
happening and how it differs from what you expect.

Have you tried creating a table in Access with the fields you need? The
names of the fields must be exactly the same as the column headings in
Excel.

Use Text fields for the LastName, FirstName and SSN.

Excel date values normally import satisfactorily into Access date
fields, so try that first; if it fails, try making this a date field
tool.

If what you call Yes/No fields in Excel contain TRUE or -1 for Yes, and
FALSE or 0 for No, they should import into Access boolean (Yes/No)
fields. Otherwise, import them into text fields.

Post back if you have further problems, or need help converting text
fields into date or boolean fields.
 
Thanks! I slowly tried to make the field datatypes as generic as possible. I
eliminted the date attribute and the boolean values to no avail. So i
striped it ALL THE WAY DOWN to FirstName and tried to load it into a table
called name with one column and an ID, it still didn't load.

The only thing that worked was just allowing Access to create a new table
from scratch which had the attribute headings spelled as i wanted at the top.
I should have thought to do this hours ago. But i'm still frustrated
wondering why this didn't work!
 
Now I can't enforce Referential integrity!!!!!!!!!!!!!!!

It says: "Relationship must be on the same number of fields with the same
datatypes."

The fields FK id numbers are the same and the datatype if number while the
PK number is autonumber.
 
Back
Top