Search results

I have come to the realisation that using transfertext + delete query is optimal (at least very much quicker). Thank you Namliam for all your help!!:) //Robert

Yes I agree it is extremly much faster and easier. Can I in code remove the first 8 rows in an access table? //Robert

Thank you Namliam for your reply, Will do the code tags next time and disambiguate! I have looked at the transfer spreadsheet command, however if I want to skip the first rows with headers and stuff then I don't see any other way than below...:confused:. Cheers Robert

Hi all, This is my first post in this forum. I am a avid excel user but I am realizing the power of access. I have tried to find a thread that matches what I am looking for but to no avail. Basically what I am trying to do is to import several text files, via vba, that have headers and lines in...