From Exel to Access trough VB ?

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

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

Quote:

---

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

---

.

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.