importing only one column

[Michael.Reynolds1775]

I am attempting to import one column from an excel sheet into a table and am not achieving the desired results.

My table is created with a primary key of the employee ID and a bank column with a field name of "MEAL CARD" along with several other elements.





Simply stated, I'd like to import the following information from excel into this table:



The steps I am taking to perform the import are as follows:

-click external data, import excel.
-in the get external data wizard, I select the file name that includes the employee ID number and meal card number, and select append a copy of the records to the table: Main Personnel.
-I select sheet 1, click next
-headers are created, click next.
-Finish

I receive the following pop-up:



The information never updates the table, as the meal card column is still all blank....

Any thoughts or help would be greatly appreciated!
-Mike

[NTC]

EDIPI as the key field - cannot have duplicates - and so your append query is probably seeing duplicates. that's my first guess.

Possibly Meal Card field is set to be Required = Yes - and so those null fields are the problem. second guess

but in the end you are attempting to append in data that violates the table's rules for some reason...

[Patrick9]

This is extremely decent and tolerable post...You shook posting it...Thanks a ton for posting it...!!!




_________________
J0hn