Sounds simple but...........
I have an existing database with a membership table consisting of about 40 fields. I want to transfer this data to a new system using Excel as the interchange mechanism.
The corresponding table in the new system (not Access based) consists of about 70 fields. Some of these fields are common in format. Some do not exist on my system and need to be populated with assumed values (Yes/No, Null etc.) and some need manipulation from the old to the new formats e.g. a Yes/No field will need expanding to a text value and concatenated with similar Yes/No fields into a single Memo field.
Obviously quite a lot of VBA code is necessary to achieve this but the issue I don't understand is how to easily create an INSERT INTO statement from some 70 fields where the source data for each field is one of:
Any help appreciated!
I have an existing database with a membership table consisting of about 40 fields. I want to transfer this data to a new system using Excel as the interchange mechanism.
The corresponding table in the new system (not Access based) consists of about 70 fields. Some of these fields are common in format. Some do not exist on my system and need to be populated with assumed values (Yes/No, Null etc.) and some need manipulation from the old to the new formats e.g. a Yes/No field will need expanding to a text value and concatenated with similar Yes/No fields into a single Memo field.
Obviously quite a lot of VBA code is necessary to achieve this but the issue I don't understand is how to easily create an INSERT INTO statement from some 70 fields where the source data for each field is one of:
- Direct copy form source table;
- A value derived from the source data;
- A constant value.
Any help appreciated!