Cmd Button Export Data From excel to Particular Table In Ms-Access Vba

[johnexcel]

Dear Expert

I have synchronized 3 Table Like DispatchCalls,ClosedCalls,CancelCalls I need to add data from xls file to these tables day by day

I want pull data through CMD button in Form to pull data from particular folder extract data from particular file
For E.g
I have Dispatch,Closed,Cancel report in paricular folder in xls ,

If i click Dispatch Button first clear old data in Table then it pull data from this dispatch file to paste into table "dispatch calls"
If i click Closed Button first clear old data in Table then it pull data from this Closed file to paste into table "Closed calls"
If i click Cancel Button first clear old data in Table then it pull data from this Cancel file to paste into table "Cancel calls" .

at any cost table name shouldnt chance.

find the attachment of Onsiteexport is Ms-Access where data export from excel &


3 xls file data move to exact table

[ranman256]

Make a table with the values DispatchCalls,ClosedCalls,CancelCalls ) the user can pick in a combo box.
This combo would have macros for each value above.
Click the button, it executes the macro in cboBox.column(1)

The dspatchCalls value would run macro: mImpDispatch.

The macro mImpDispatch: would
clear target table
import linked xl file data

[johnexcel]

Dear sir
can u upload output file? I quite new beginner of ms-access vba?

[rpeare]

Why would you flush the information, why not link directly to the excel files, linking the excel files would be more 'real time' than importing the information once per day.

[johnexcel]

How to link directly to excel file to msaccess table... ? can u teach step by step? i will do myself I work on 2007 version. please sir

[rpeare]

http://office.microsoft.com/en-us/ac...001219419.aspx

[johnexcel]

Thanks Master It works Fine ...Amazing Helps.even i learned How to do Import&EXport data.. Thanks alot.

Can u help on my another thread..
https://www.accessforums.net/forms/n...tml#post229056