Good day wonderful people!
I have made great strides in building an Access to Excel Export / Import set up. As long as the primary keys aren't Autonumbers. Basically, I Export all the fields that can be nicely imported (eg. no calculated fields) after making some changes in Excel. I need the PK field for the UPDATE query that i run after I run an APPEND (INSERT INTO) query. After much Googling, i arranged it so the blank PK field isn't in the INSERT statement, but I am still getting the Import Error tables about the Null Value in a Autonumber field.
The basics:
1. I Export :
Code:
SELECT FT_ID, FIWP_No, Tag_No FROM FIWP_Tag_List
2. I Import to a Temp Table: tmp_FIWP_Tag_List (Same Fields)
3. I Append:
Code:
INSERT INTO FIWP_Tag_List ( FIWP_No, Tag_No ) SELECT tmp_FIWP_Tag_List.FIWP_No, tmp_FIWP_Tag_List.Tag_NoFROM tmp_FIWP_Tag_List LEFT JOIN FIWP_Tag_List ON tmp_FIWP_Tag_List.[FT_ID] = FIWP_Tag_List.[FT_ID]
WHERE (((FIWP_Tag_List.FT_ID) Is Null))
4. I Update:
Code:
UPDATE FIWP_Tag_List INNER JOIN tmp_FIWP_Tag_List ON FIWP_Tag_List.FT_ID = tmp_FIWP_Tag_List.FT_ID SET FIWP_Tag_List.FIWP_No = [tmp_FIWP_Tag_List].[FIWP_No], FIWP_Tag_List.Tag_No = [tmp_FIWP_Tag_List].[Tag_No]
WHERE (((FIWP_Tag_List.FT_ID)=[tmp_FIWP_Tag_List].[FT_ID]))
5. I get the Error Table...
Any ideas?
Thanks in Advance!
Trev