Exporting(importing) a text file in to Access

[rathi]

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

[Lafor]

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
chris.kilhams@totalise.co.uk