Originally posted by mashinovodja
Did you try to modify the range you are importing from? Instead of "A1:j500", specify the range where the "real" table data is located.
there may be 3 blocks of data, and i have been using import into new table and then deleting the row if isnUll(rs(7)) (will be ck # ) so i dont want to go through any work formating the file, and i dont want to do file import new. Lazy guy !! but isnt that what programing is for??
Are those blocks of data always of the same known size and on the same known place in your spreadsheet, or they vary in place and/or size?
If they vary, you will have to do some programming and it may not be that simple. You will have to open your Excel spreadsheet in Access, search for blocks of contiguous data, and then import those blocks one by one in Access. All done in VBA code, no simple macros or other quick tricks, of course :-))