delete query

  • Thread starter Thread starter bigwillno2 via AccessMonster.com
  • Start date Start date
B

bigwillno2 via AccessMonster.com

i am trying to import data from an excel file that comes from a different
program, however, the field headings of the file are under two rows that
contain junk data. i need to delete this data in order to import or link this
table properly. how can i go about this? any help is appreciated. thanks
 
If it's something that you do infrequently, open up the file in Excel and
delete the junk. Then import.

If it's something done often, create a table with all the right fields then
import into this table. Chances are that these just data won't be imported.
If it is you could run a delete query to get rid of the bad records if there
is a good way to identify them.
 
Back
Top