We've been updating our Access database using paper reports generated by our road warriors. We're ready to go paperless, but not sure what the best way is create the records to be imported to Access. We have a large database (113 MB). We want our guys to be able to review some history and make notes on current meeting, then import this to Access. We could use laptops with a copy of the Access database, but concerned about being able to export just the new records and keeping the primary key (auto generated) for these records unique. We thought Excel might be better choice to hold query results and import file. Also trying to decide if laptops, tablets or pocket pcs are best to accomplish this. Any suggestions deeply appreciated!
Adrienne
Adrienne