Link to home
Start Free TrialLog in
Avatar of Scott Palmer
Scott PalmerFlag 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.  

Thanks,
Scott
 
ASKER CERTIFIED SOLUTION
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Another way would be to let Excel automate the steps with Power Query functionality before importing to Access. Just a thought.
I don't think altering the data source is a wise idea.

How are data imported in Access ?
The fix can be as little as writing (or updating) a query.
Avatar of Scott Palmer

ASKER

Thanks Ryan, worked perfectly.

Scott