Insert data into an external file

[secici]

Hi!

I use

With Sheet2.QueryTables.Add(Connection:=Array(Array( _
"ODBC;DBQ=C:MyDocumentsdbporvit.xls;DefaultDir=C:MyDocumentsdb;Driver={Microsoft Excel Driver (*.xls)};DriverId=790;FIL=excel 8." _

type of coding which I obtained from "Record new macro" feature while dealing with MSQuery. This helps me a lot when I want to get external data from another workbook. But what can I do to insert a new record to an external file. How can I export my data?

Thanks