basically, everything you see in the database NEEDS to be there. We cant modify any of it. We need all the new items.. (in some cases thousands) to append ad then re-import to our database.
Novice
Windows 7 
Access 2007
basically, everything you see in the database NEEDS to be there. We cant modify any of it. We need all the new items.. (in some cases thousands) to append ad then re-import to our database.
Administrator
Windows XP Access 2002
So the records may already exist? How can I tell if it is a new record or an old one that needs to be updated?
Administrator
Windows XP Access 2002
Are the updating Excel files going to be in different formats? Can we depend on the columns in this order or the column names being the same?
Novice
Windows 7 Access 2007
the excel file is all new. No modifications to pre-existing data.... See its actually really complicated. Not so easy huh.
Each of those items on the spreadsheet need to be imported as new items in the database.. Its basically an update to the database
Administrator
Windows XP Access 2002
So the Excel rows are *always* appended to the existing Items table right? Still not very difficult. I'll let you know when I have something.
Novice
Windows 7 Access 2007
anything yet?
Administrator
Windows XP Access 2002
Your db is an mdb yet you have ac2007 and the Excel file is an xlsx file. What will you be using?
Administrator
Windows XP Access 2002
I guess you no longer are interested in this issue.
Posting Permissions
Reply With Quote
