Help with VBA Excel - import fifth excel sheet in a workbook to access table

**ewong** · 08-31-2012, 02:10 PM

Hi guys,

I need help with my VBA code. Totally new with the whole programming stuff so bear with me.

Here is the code that I have right now.

Please Login or Register  to view this content.

When I run the code (F5), it generated an error message "Run-time error '424': object required"... What did I do wrong here?

Thanks!

**arlu1201** · 08-31-2012, 02:42 PM

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature.

**alansidman** · 08-31-2012, 11:15 PM

I think the issue may be in your spreadsheet type. You have listed TypeExcel8 which is an Excel 97 worksheet, but the spreadsheet name alludes to a 2007/2010 spreadsheet.

Look here for help on that.

http://msdn.microsoft.com/en-us/libr...ffice.12).aspx

**ewong** · 09-10-2012, 01:20 PM

Hi,

I've mostly fixed the code. The code works however there's a minor issue that i'm sure it's quite easy to fix.

when i ran the code, there was this additional 8 extra empty records (rows) in access.

i only have 9210 rows of data in excel but because of this 8 extra columns, it ends up being 9218 rows in access. here's the code that I have now:

Please Login or Register  to view this content.

can anyone help me on this? thanks!

Originally Posted by alansidman

I think the issue may be in your spreadsheet type. You have listed TypeExcel8 which is an Excel 97 worksheet, but the spreadsheet name alludes to a 2007/2010 spreadsheet.

Look here for help on that.

http://msdn.microsoft.com/en-us/libr...ffice.12).aspx