Delete Fields from Table

steallan

Registered User.
Local time
Today, 09:13
Joined
Feb 9, 2005
Messages
46
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
 
How are you getting the data/table? Is it being given to you as a .csv or text file?
 
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
 
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.
 

Users who are viewing this thread

Back
Top Bottom