Hi everyone,
I want to export a comma delimted text file in to an Access table. Is there any VB command to do this?
Your help is greatly appreciated.
Thank you.
Rathi.j
Printable View
Hi everyone,
I want to export a comma delimted text file in to an Access table. Is there any VB command to do this?
Your help is greatly appreciated.
Thank you.
Rathi.j
One thing we should never neglect before submitting a post is to do a search before.... in VB world... Here is what I found...doing so... I think Chris may have tackled this before
Dim Myaccess As Access.Application
Set Myaccess = CreateObject("Access.Application")
With Myaccess
.Visible = False
.OpenCurrentDatabase "Cool.mdb"
.DoCmd.TransferText acExportDelim, , lstExport, txtName
.Quit
End With
Trouble is...it asks for the database password which I would rather hard code..any ideas where I can put it?
__________________
- Chris
[email protected]