Importing Spreadsheets

[Hemish]

Hi,

Is there a way of importing MS Excel Spreadsheets but starting from row 8.
I am now getting lots of spreadsheets but i only need data from row 8. I have to manually delete the rows and save the spreadsheet then import. Some days i can have more then 1.

If you got any ideas i appreciate it.
Thanks

 

[Anakardian]

If you are absolutely sure they all start from row 8, you can delete the first 7 rows through vba and then import the entire sheet.

For deleting the rows you don't need, you can find some inspiration here.

For the import bit you can use the DoCmd.TransferSpreadsheet Method

 

[mh123]

You could import it to a tmp table like impSpreadsheet then with your button 'on click' import the file to tmp, then just move the data from row 8 or whichever row you need into the the designated table?

Once the move's successful delete the imp table as it's no longer needed?