From Exel to Access trough VB ?

[dialafc]

Hello. I have a rather big list of songs i have in Excel. I wonder if there is a way i could programm in VB so that i can pick the information from excel and place it into Access ? I know how to get info itno Access from Visual Basic, but not from Excel. Ill be gald to see any ideas and examples

dial

[OneSource]

Hi dialafc,

If you just want to get the info. from Excel into Access. You can Import it from the File menu in Access.

Hope this helps.

------------------
OneSource

The truth may be out there, but it's in here too!

.

[CYBERMATRIX]

In Visual Basic , Go To References, Then Look For The
"Microsoft Excel Library" And Add It To Your Project.

Once You Have Done This , You Create A Variable.

Then You Say>>varName = Excel.Application
Set varName = New Excel.application

If You Don't Know Where To Go From Here Keep Me Posted.