Recent content by maheshkava

all, I have to create a batch file to be distributed to our end user,on the execution of which a task schedule would be created on the user machine which would run a batch file.we cannot ask the end user to manually create a task schedule themself. I tried using the 'AT' command from the command...

Thankx VBSlammer for all ur help,time & patience.I really appreciate that.IT DID WORK!! :-)

hey VBSlammer! thankx for all your help but m getting a Runtime error 3625 'The text file specification ImportTest Import Specification does not exist' on this line DoCmd.TransferText acImportDelim, "ImportTest Import Specification", "aggregated", "C:\test1.txt&quot...

Thankx VBSlammer for ur help..it did work(if i create a ImportSpecification). BUT..I have to create a new Database for every text file i import,which means that i have to create a new database manually & then create a ImportSpecification for the db every time i need to import a file. That means...

Thankx vb6novice for ru tip..i appreciate that, but i have already tried that out by leaving the specificationname blank & also using double quotes.But i still get the Unparsable Record import error. mahesh

check the column name - ptSystemID. Access is not recognizing the column name. Make sure its spelled correctly & exists.

all, I am trying to import a tab delimited text file into a access table.The field names & values are seperated by double quotes.I am using the TransferText method for this purpose: AccessApp.DoCmd.TransferText acImportDelim, "", "aggregated", "c:\test1.txt", True...