If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: Import over 255 to Access 2010

I’ve been on the internet now for a couple hours with no success.

I’m using MS Office 2010

I have a excel spread sheet with around 18,000 rows, and 16,475 columns
The 16,475 columns always are the same. So what I’m trying to find is if there is a way I can import this spread sheet into access. Understanding that access has a 255 limitation.

I’m wondering if there is a way I can have access go out to the spread sheet and grab column” A, B , C, D, Z, AE, AZ, etc.,”<-as a example

Then go back and grab more columns until I have all the columns in different access table from columns that were in excel

You can use Automation to create an instance of Excel into your Access database, then use it to open the Excel workbook and read the data it contains in any way you want:

Code:

Dim appXL As Excel.Application
Set appXL = New Excel.Application
With appXL
.Workbooks.Open FileName:=DocName
'
' Read the contents of the Excel file.
'
.ActiveWorkbook.Close
.Quit
End With
Set appXL = Nothing