Im trying to import from an existing Excel database, but the fields arent the same..which is causing problems.
Since I know its easier to point from field to field in Excel, Im thinking of making a new,blank spreadsheet with the field headings from the Access Database that I ultimately want to bring things into.
The [B]problem [/B] is the form I want the records to go into has a subform. Should I split the imports? If I do, will the subform be added to the right masterform if the overlapping/ID fields have values?
Ideas?
Thanks.
UPDATE:
Ive imported the Excel file into a NEW table...but how do I transfer the info over?
Since I know its easier to point from field to field in Excel, Im thinking of making a new,blank spreadsheet with the field headings from the Access Database that I ultimately want to bring things into.
The [B]problem [/B] is the form I want the records to go into has a subform. Should I split the imports? If I do, will the subform be added to the right masterform if the overlapping/ID fields have values?
Ideas?
Thanks.
UPDATE:
Ive imported the Excel file into a NEW table...but how do I transfer the info over?
Last edited:
