I'm trying to import a single MS Excel file into an access database without using any VBA coding. Basically, I just want to use the Macro of the file... you know, where it reads:
Transfer type,
Spreadsheet type,
table name, ...
Range

Easy enough to do, except I can't get the range right. I only want to import two different sections of the file (B2:F40, J2:O40)
How can I do this, does anyone know?

BTW, this is what I have so far:
Range = Base!(B2:F40,J2:O40)
where base is the name of the sheet in that file

I can't add any more columns in access, and I can't move the columns in excel, and it's for an HR database.

[Edited on January 10, 2007 at 10:02 PM. Reason : cant]

1/10/2007 9:51:41 PM

Open the spreadsheet in MS Access. It has a tool for importing Excel spreadsheets.

1/10/2007 11:30:18 PM

Thanks, that would work but I forgot to mention it had to be a one hit/one button action. But the problem is solved! I just made another spreadsheet in the same workbook(file) and used a single range off of that.

[Edited on January 10, 2007 at 11:40 PM. Reason : range]

1/10/2007 11:39:39 PM