DELETE column in TABLE
in [Queries]
|
From: GoodLook on 17 Mar 2010 05:46 Hi all, Is it possible to create a query that DELETES column in a table in ACCESS 2007? the reason is, because I receive a very big database from my supplier, I need to delete a large number of column that are not needed by us. now there are 200 fields and i only need 15. when publishing to complete database it takes to much time and is way to big in file Size. regards, Geert
From: PieterLinden via AccessMonster.com on 17 Mar 2010 06:50 GoodLook wrote: >Hi all, > >Is it possible to create a query that DELETES column in a table in ACCESS >2007? >the reason is, because I receive a very big database from my supplier, I >need to delete a large number of column that are not needed by us. >now there are 200 fields and i only need 15. > >when publishing to complete database it takes to much time and is way to big >in file Size. > >regards, >Geert Set up your import specification to not map all of the fields. That way, only the fields you specify will be imported. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201003/1
From: PieterLinden via AccessMonster.com on 17 Mar 2010 06:57 GoodLook wrote: >Hi all, > >Is it possible to create a query that DELETES column in a table in ACCESS >2007? >the reason is, because I receive a very big database from my supplier, I >need to delete a large number of column that are not needed by us. >now there are 200 fields and i only need 15. > >when publishing to complete database it takes to much time and is way to big >in file Size. > >regards, >Geert One way to solve the problem: 1. Create a blank database. 2. create a linked table pointing to the database table with all the data. (File, Get External Data) 3. create a MakeTable query that includes just the columns you want in your table. 4. save the query and run it. 5. add the indexing to your table. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201003/1
From: Jerry Whittle on 17 Mar 2010 09:30 ALTER table TheTable drop ExtraField; Even if you drop a bunch of fields, don't be surprised if you have trouble if you try to add fields to the table in the future. Access tends to remember the number of fields that have been in the table in the past. A compact and repair may help. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "GoodLook" wrote: > Hi all, > > Is it possible to create a query that DELETES column in a table in ACCESS > 2007? > the reason is, because I receive a very big database from my supplier, I > need to delete a large number of column that are not needed by us. > now there are 200 fields and i only need 15. > > when publishing to complete database it takes to much time and is way to big > in file Size. > > regards, > Geert
From: GoodLook on 17 Mar 2010 09:40
I tested both methods and this method is not so good. when mapping, first time is works great. When the supplier changes the field order, or some fields or deleted then it go wrong and it is not possible to import at all. ( I simulated with deleting some fields in the database to import. working with a linked table is best, because of the flexibility of the query. Thanks you very much for the very fast and correct response. You folks are great ! --------------------------- Your Partner for Quality "PieterLinden via AccessMonster.com" wrote: > GoodLook wrote: > >Hi all, > > > >Is it possible to create a query that DELETES column in a table in ACCESS > >2007? > >the reason is, because I receive a very big database from my supplier, I > >need to delete a large number of column that are not needed by us. > >now there are 200 fields and i only need 15. > > > >when publishing to complete database it takes to much time and is way to big > >in file Size. > > > >regards, > >Geert > > Set up your import specification to not map all of the fields. That way, > only the fields you specify will be imported. > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201003/1 > > . > |