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:
Dim appXL As Excel.Application
Set appXL = New Excel.Application
' Read the contents of the Excel file.
Set appXL = Nothing