Hello Everyone,
I have an existing MS Access Database and I need to create an append query that will look at a MS Excel file and add only certain specific columns to the DataTable of my MS Access Databse. For Example I only want the data contained in Column A - B - C in the MS Excel File to be a added to my database in the customer ID - Customer Name - Customer Zip fields of my MS Access Database.

Can someone give me an example how the SQL query would look like in Access?

Thanks

Joe

Start by linking the excel worksheet.
Use the QBE to create a select query that selects the columns you want from the linked worksheet.
Change the query type to append and choose the name of the table you wish to append to.
If the column names of the sheet and the table are identical, the "Append To" column name will automatically populate. If they are different, you will need to go to each column and manually select the column to append to.
Save the query and run it.

Thanks for breaking down this for me!!

Once you get the hang of it, the QBE is very useful for building the basics of most queries. I only switch to SQL view when I have complex criteria.

Once you get the hang of it, the QBE is very useful for building the basics of most queries. I only switch to SQL view when I have complex criteria.

Nice to know I'm not the only one who still does that :)