It woulkld be easy to to inf you record a macro while perfroming a databae
query. I can then use the SQL from the read to create the write macro.

1) Start Recording a macro
2) go to worksheet menu

Data - Import External data - new database query

3) retrieve the same records you plan to write.
4) stop recording and post your macro.

"prabhu s" wrote:

Hi..
This is prabu. i have a question. i want to insert excel record
into access(not import or export).

i have text box in excel sheet Name, age, address & i have one button.
once i hit the button. all record insert to access.
can you help me for this.