Delete the First Row - Tables

[Tempest]

Hi All,

has anybody ever had a macro to delete the first row or seen something similar, I know you can do it manually but I am trying to avoid this as dont want the user intervention their is a line of text above the table names that I want to remove and ignoring it in the first import dosent work.

Any help muchly appreciated.

Cheers,
Mark

 

[Ron_dK]

I assume you're importing an excel sheet into Access.
In stead of using a macro, you might create a query based on the imported table record set and filter out the first record.

For instance :

Table1:
Field1 Field2
texthere sometext
34567 Manufacturer
11188 CompanyX

Query :
SELECT Yourtable.Field1, Yourtable.Field2
FROM Yourtable
WHERE (((Yourtable.Field2) Not Like "some*"));


Hth