Hello,
I want to create Access datatbase(table) from a Text file(NotePad),Access read records from text file through coding, not through Wizard, so any one have any clue how to do this, pls tell soon,What functions we used in it, how to create Access connection with a Text File through coding?
pls HELP

[This message has been edited by Amber786 (edited 12-11-2001).]

try looking at DoCmd.TransferDatabase for what you need.

If you can not figure it out from there email me and we can talk about it.