Delete Fields from Table

[steallan]

Hi

Is there a automatic way i can delete Fields from a Table? This table gets input into the database very frequently as updates come in and i'd like something like a Query or Macro, where i can define which fields i dont want, to delete the 30+ columns of useless data.

Can't see how to do it with a Query or macro though

Anyone have any ideas?

Thanks

 

[KenHigg]

How are you getting the data/table? Is it being given to you as a .csv or text file?

 

[steallan]

Import table with structure straight from another database.

You reminded me I could set it to not import the fields then, That takes a while though coz the table is so big and scrolling through all the fields ticking "dont import" takes time, but thats an option

Quicker way once the table is in access would be better. Although i guess there may not be one as needing to delete loads of fields is probably rare

 

[KenHigg]

Can't you link to it?

 

[steallan]

No dont want to link to it, prefer it all in one

 

[neileg]

I presume the table has the same structure all the time? If so, import it complete to a predefined table, run a query that selects only those fields you want and append the data to another table with your preferred structure. Delete the records from the import table ready for the next time.