Delete column before export

[xopherira]

Does anyone know how to delete the first column in an export to excel. I am adding a primary key to imported table but do not want to export to final spreadsheet.

[June7]

Export a query that does not include the field.

[xopherira]

Is there a way to do keeping the format of spreadsheet? Currently I am using ImportExportSpreadsheet macro whichs saves and exports loads the correct "template" format.

[June7]

I don't use macros. But using query should be no different from using table.

[xopherira]

The problem that I have is when I don't use the Access macro I can't keep the formatting of the spreadsheet. Sure I can export, but I lose the spreadsheet formatting in terms of font and color.

[June7]

With a query?

[xopherira]

I dont't think I understand. So are you suggesting I do what ever processing I need to do with imported table, then run query to delete column before export?

[June7]

Actually delete the column from table if you want but a query object could be built that just does not include the field. Then export the query. What do you not understand about exporting a query object? Reference query object same as referencing a table object.