Posted to microsoft.public.excel.programming

K[_2_]

external usenet poster

Posts: 557

Export Data from Excel into existing Table in Access

Hi all, I got Access Database on path "C:\Data\Rec.mdb". I got one
table in that database with the name "Table1" with five columns in
it. I want macro in excel which should delete all the records in
"Table1" and then copy Range("A2:E100") of Sheet2 and paste it into
"Table1". (Note: headings in Range("A1:E1") of Sheet2 are exctly
match with the "Table1" headings). Please can any friend help me on
this. I dont know if its possible or not!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Export Access Table to Excel	Don[_27_]	Excel Programming	2	September 27th 06 03:39 PM
Macro to Export Selected fields to an Existing Access Database	ernie	Excel Programming	1	March 13th 06 05:01 PM
Data From Excel Range To Existing Access Table	Jason	Excel Programming	16	December 2nd 05 09:14 AM
vb code to export data into existing Access table	desperate	Excel Programming	2	November 19th 03 05:05 PM
Export Data to Access Table	Pete T[_2_]	Excel Programming	1	October 10th 03 11:47 PM

All times are GMT +1. The time now is 06:20 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us