Reprting Analyst

Scott Palmer

<div>
Another way would be to let Excel automate the steps with Power Query functionality before importing to Access. Just a thought.
</div>


<div>
I don't think altering the data source is a wise idea.<br><br>How are data imported in Access ?<br>The fix can be as little as writing (or updating) a query.
</div>


<div>
Thanks Ryan, worked perfectly.<br><br>Scott
</div>


<div>
<div class="content wysiwyg-content fr-view">
I have to import many Excel spreadsheets into Access everyday. &nbsp;Unfortunately in their original form Access won't import them. &nbsp;Here is an example of the spreadsheet.<br>&nbsp;<table><tbody><tr><td>#</td><td>PR</td><td>Name</td><td>&nbsp;Type of Facility</td><td>City</td><td>State</td></tr><tr><td>1</td><td>564855</td><td>Man Electrical</td><td>IOP</td><td>Chico</td><td>CA</td></tr><tr><td>2</td><td>164585</td><td>Loma Part Place</td><td>HOS</td><td>Redding</td><td>CA</td></tr></tbody></table><br>In Access using VBA I need to to delete the first column and trim the title of the "Type of Facility" column. &nbsp; <br><br>Thanks,<br>Scott<br>&nbsp;
</div>
</div>



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.
 
#
PR
Name
 Type of Facility
City
State
1
564855
Man Electrical
IOP
Chico
CA
2
164585
Loma Part Place
HOS
Redding
CA
In Access using VBA I need to to delete the first column and trim the title of the "Type of Facility" column.  
Thanks,
Scott
 

Trim cells and Delete columns in Excel using Microsoft Access

Microsoft is best known for their Microsoft Windows line of operating systems, the Microsoft Office suite, and the Internet Explorer and Edge web browsers. Microsoft's mission is to "enable people and businesses throughout the world to realize their full potential by creating technology that transforms the way people work, play, and communicate.” Currently, the Windows operating system created by Microsoft powers over a billion devices around the world. On top of their share in the software creation market, Microsoft manufactures hardware, including laptops, phones, and attachments.

Microsoft

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

#	PR	Name	Type of Facility	City	State
1	564855	Man Electrical	IOP	Chico	CA
2	164585	Loma Part Place	HOS	Redding	CA