Importing and Excel Sheet to MS Access

[BilalR]

Hi..
Any one there can help me figure out how i can import excel sheet into MS
Access, but make access start importing from row number 4 in the excel
datasheet.

thanks.

 

[cclark]

This is the exact question I have also.

How do you make access start importing from row number 4 in the excel
datasheet? Is there a way to specify a "Start Row"?

Thanks
cclark

 

[Pete D.]

If you know the range use a macro transfer spreadsheet where you can specify
a named range or A4:Z100 or whatever. If you want to get really into it you
can check out this article but it requires some understanding of VBA. Good
news is it includes a sample database and spreadsheet to teach yourself.

http://www.databasejournal.com/feat.../3557541/Import-Data-from-Microsoft-Excel.htm

 

[Ken Snell \(MVP\)]

Write Data From an EXCEL Worksheet into a Recordset using Automation
http://www.accessmvp.com/KDSnell/EXCEL_ImpExp.htm#WriteFileRst