| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import Access data to text file rather than Excel
I have the below code (copied from this forum) to extract data from Access
and copy it to the active Excel worksheet. What I want is for that last line to copy the data to a txt file, and save that file with name "myText.txt" to L:\Storage\ Thanks in advance! Daniel Bonallack _____________________ ' Open the connection Set Connection = New ADODB.Connection Cnct = "Provider=Microsoft.Jet.OLEDB.4.0; " Cnct = Cnct & "Data Source=" & DBFullName & ";" Connection.Open ConnectionString:=Cnct ' Create RecordSet Set Recordset = New ADODB.Recordset Recordset.Open Source:=SQLString, ActiveConnection:=Connection Range("A1").CopyFromRecordset Recordset |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I import data from a text file into Excel 2003 | Excel Discussion (Misc queries) | |||
| How do a import data from a text file to an excel worksheet | Excel Discussion (Misc queries) | |||
| Import text file to access database via Excel VBA | Excel Programming | |||
| import excel file to access but only new data | Excel Programming | |||
| Excel file will not import to Access, what may be the cause | Excel Discussion (Misc queries) | |||
Threaded Mode
