Avatar of Scott Palmer
Scott Palmer
Flag for United States of America

asked on 

Trim cells and Delete columns in Excel using Microsoft Access

I have to import many Excel spreadsheets into Access everyday.  Unfortunately in their original form Access won't import them.  Here is an example of the spreadsheet.
#PRName Type of FacilityCityState
1564855Man ElectricalIOPChicoCA
2164585Loma Part PlaceHOSReddingCA

In Access using VBA I need to to delete the first column and trim the title of the "Type of Facility" column.  

MicrosoftMicrosoft AccessMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Scott Palmer

8/22/2022 - Mon