MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Exce sheet using VBA

  Asked By: Colleen    Date: Feb 12    Category: MS Office    Views: 1609

I have already stored some data in excel sheet,
how to export this to Ms access Database,using vba code.
please help me,



2 Answers Found

Answer #1    Answered By: Sophie Williamson     Answered On: Feb 12

You don't need to write code  ( it may be varies according to your requirment)
u can directly link ur Excel into Access
Pls try this Open ur DB(Access)

Goto File>Get Entrenal data>Link table
In this way whenever you make any changes into Excel It will reflect to your
Access DB

Other way, Excel gives you a facility to creat you own table in Excel.
Please read the help  "Name cells in a workbook"
Now you can use ADO to load the data  into Access DB

Answer #2    Answered By: Hattie Howard     Answered On: Feb 12

I want store data  from to excel  sheet,at a time check the DB , if db values
and textbox values are same not stroe in the excel sheet,(check db values after
that add excel sheet),

If txtbox1 values store only one time but txtbox2 values store more then 100
time,(both excel sheet  and DB)

Didn't find what you were looking for? Find more on Exce sheet using VBA Or get search suggestion and latest updates.