Import Microsoft Excel selected fields into Microsoft Access table

1102235 pts.
Tags:
Microsoft Access
Microsoft Excel
Is there a code out there that anyone knows about that would allow me to import Microsoft Excel selected fields into an existing Microsoft Access table? Or maybe a setting? Any help would be appreciated. Thanks.

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Subhendu Sen
    This is just a concept/idea. It is a common practice to use the TransferSpreadsheet method to import all of the fields into a table, then by using a query to append only the fields that you wanted into Access destination table. This ensures that, the data ends up in Access table is in the correct format. For TransferSpreadsheet method, please link here: https://msdn.microsoft.com/en-us/vba/access-vba/articles/docmd-transferspreadsheet-method-access
    120,610 pointsBadges:
    report
  • ToddN2000
    It can be done. It depends on what you are looking to move. Are you looking to move entire columns, select cells or something else? You best bet would be to write a script to do it. Not knowing your specific needs or coding language you may be familiar with we can't help with the code until more info is given.
    115,635 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: