Macro to importing a text file to populate a database/table
 

I know Access has a way to populate a database. But does Excel have a way to
populate a table so you can push a button and it populates and open all in
one shot?

Macro to importing a text file to populate a database/table
 

There is no button, as such. You can create one by using the Macro Recorder
and performing the tasks you wish, and then assigning that macro to a button.

hth
Vaya con Dios,
Chuck, CABGx3



"TKM" wrote:

I know Access has a way to populate a database. But does Excel have a way to
populate a table so you can push a button and it populates and open all in
one shot?