Mapping fields in Excel to prepare them for Access import.

anyone have any ideas?

anyone have any ideas?

Thanks.

still looking for help with this. I would appreciate any help.

Thanks.

Originally Posted by alansidman

The first thing I note is that the fields you have named in your thread are not related to the field names in your spreadsheets. How about identifying which fields in which spreadsheet you want. Something like example1.ownerfirst concatenated with example1.ownerlast,etc. Otherwise we will not know what you want.

alright sounds good. I'll post more detail. Thanks.

Example 1
Full Name- Ownerfirst ownerlast
Mailing Address- mailnumber, mail street
Mailing City- mail city
Mailing State- mail state
Mailing Zip- mailzip
Property Address-site Number, site street
Property City-site city
Property State-sitestate(if listed)
Property Zip-site zip

Example 2
Full Name- Ownerfirst ownerlast
Mailing Address- mailnumber, mail street
Mailing City- mail city
Mailing State- mail state
Mailing Zip- mailzip
Property Address-site Number, site street
Property City-site city
Property State-sitestate
Property Zip-site zip

Example 3
Full Name- Ownerfirst ownerlast
Mailing Address- mail address
Mailing City- mail city
Mailing State- mail state
Mailing Zip- mail zip code
Property Address-property city
Property State- property state
Property Zip- property zip

Here is a list of each examples field names I need for each column. I attached an excel file I'd like to paste the correct columns into. I hope this helps. Thanks again for any help.

any ideas i get a data mismatch error

anyone have any ideas?

I just want the macro to work with all three files.

for instance I will get file example 1 but The ONLY fields I need would be:
Full Name, Mailing Address, Mailing City, Mailing State, Mailing ZIP, Mailing Country, Property Address, Property City, Property State, Property ZIP.

Then I would save it so I can import into my database.

I just need it to work with all three example files because those are the three files I am currently receiving. If I could get it where I could pull the fields I need out of any 3 of the example files and save it as a new excel file sheet then it would save me a lot of time.

My example was to show what field names from each file pasted under the file name in my field names attachment.

Does it make sense now?

anyone have any ideas?

thanks ill try this in the morning.

i believe these are the only 3 file structures.

I appreciate the help. I have a folder in my C drive called Access where I put a sample file. It doesn't seem to paste any of the values. I can't figure out what to do. Anyway you could run a test on it with my example files.

Thanks.

anyone have any idea on why the code won't paste any of the columns. It seems like it copies data just doesn't paste?

Still doesn't seem to paste any of the information. I am really new to vba code so I am not too sure what I should do to try to make it work. It seems to have the right intention though. To grab columns from a file placed in a folder and copy the columns I am looking for into the excel sheet.

Wow I think that's it. I am going to test this but that seems to work well. I don't know what I did wrong with my file but using your attachment it worked. Thank you very much.

I have one question so if I come up with other header names do I just put them by the case it goes with?

Alright. Thanks. I seen that in his reply but wasn't sure if it was referring to the Case statements or not.

Thanks.