Eimport from excel

  • Thread starter Thread starter EMILYTAN via AccessMonster.com
  • Start date Start date
E

EMILYTAN via AccessMonster.com

I have a table structure same as the table structure in excel. When i click a
button, i want it to directly load it in the table...
How?
 
In order to do this, you will need to become familiar with VBA coding. You
can use the Docmd.transferspreadsheet method. This will allow you to specify
where the file is from and what the table that you are importing to is called.

Please let me know if I can provide more assistance.
 
ACCESS also has a macro action to do the TransferSpreadsheet action -- VBA
not needed if you use the macro.
 
I need to know more on that as this is the first time I am doing this....
Thank you
 
May I knwo the way please
Ken said:
ACCESS also has a macro action to do the TransferSpreadsheet action -- VBA
not needed if you use the macro.
In order to do this, you will need to become familiar with VBA coding. You
can use the Docmd.transferspreadsheet method. This will allow you to
[quoted text clipped - 8 lines]
 
I want to import my excel spreadsheet to my access and I want only a selected
field to appear...
Besides, I dont want only load that selcted excel.
For example, when I click a button it will open the folder that contain the
spreadsheet, then user can select which 1 to load..and after selecting, it
will auto load to the table.
May I know the way?
 
Hi everyone! My idea is open a folder and let the user browse their desired
excel file.
So, i have a browse button that will browse the path and the path will be
displayed in the text box..Well, this can work well.
My problem is I want a button to load the excel document to the table and I
only want to load specific column only into the table based on the browsed
path in the text box..
How?
 
TransferSpreadsheet is a macro action. It's explained in Help files. Create
a new macro, select TransferSpreadsheet as the action, and the arguments
will be fairly self-explanatory.

--

Ken Snell
<MS ACCESS MVP>


EMILYTAN via AccessMonster.com said:
May I knwo the way please
Ken said:
ACCESS also has a macro action to do the TransferSpreadsheet action -- VBA
not needed if you use the macro.
In order to do this, you will need to become familiar with VBA coding.
You
can use the Docmd.transferspreadsheet method. This will allow you to
[quoted text clipped - 8 lines]
button, i want it to directly load it in the table...
How?
 
Back
Top