Delete Fields In Table With VBA

[Juan4412]

I have a table where I want to delete fields (whether they include data or not). The table name is ExcelImport and the field names I want to keep are registrationID, registeredBy, registrationDate. All other fields in the table should be deleted. How is this achieved using VBA/

[JoeM]

I think I would be more apt to use a Make Table Query or an Append Query to write the fields that I want to a new table, and delete the old table afterwards.
If you are trying to set-up a process that you can use over and over with imported data, I would do the following:
- Set-up a blank table that has the three fields you want.
- Import your data into a temporary table
- Use an Append Query to write the data from your temporary table to your final table
- Blank out all records in your temporary table for the next run

[JoeM]

If you really want to delete the fields from the one table, have a look at these methods here:
https://msdn.microsoft.com/en-us/lib.../ff196148.aspx
https://msdn.microsoft.com/en-us/lib.../ff821417.aspx

In my opinion, the first method I suggested is easier, in that you can do it all with Macros and doesn't require you to create any custom VBA code.

[Juan4412]

Such a simplistic approach, I like it. I have never done a make table query with VBA - what is the syntax for that?

[JoeM]

It is just another Action query.
See: https://support.office.com/en-us/art...4-e21ad0a94f1b

Personally, I prefer the approach of setting up a blank table structure first, and then using an Append Query instead.
The reason for this is simple: you can control the field types of the data, and set up key fields, and indexes exactly the way you want them.
Otherwise, Access will "guess" as to what field types to use, and may not choose the ones you want. I prefer having the control instead of Access!