delete query

  • Thread starter bigwillno2 via AccessMonster.com
  • 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
 
J

Jerry Whittle

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.
 
Top