File Import

[Daniel Pineault]

Lookup the

DoCmd.TransferSpreadsheet

Method in the help file.
--
Hope this helps,

Daniel Pineault
For Access Tips and Examples: http://www.cardaconsultants.com/en/msaccess.php
If this post was helpful, please rate it by using the vote buttons.

 

[Dirk Goldgar]

TransferSpreadsheet will create the table if it doesn't already exist.

 

[a]

How to programmatically import excel sheet by using command button in the
form

The excel file Name (MyExcel)

My excel file path C:\MyExcel

First row contain column heading (true)

(((In a new table )))

Can we do that by code

Note by manual

 

[a]

thank you for your help and answer
but this Method requer table
I want Import excel sheet to (New Table) not exisiting table
Thank you