Hi
have loads of spreadsheets that I want to import into a linked table structure.
I can see three scenarios:
split the spreadsheet into sections and import each section into the database table
import the spreadsheet into a table and then run multiple updates to the linked fields - not sure how that would keep the key structure
create a query using fields from all tables and then run an append on the query - is this even possible?
would appreciate any thoughts
thanks
Ian