[RESOLVED] export data from msaccess to txt file....

[asamy]

hello,


I hope thet someone can help me

I have databese in access 2000 named db2.mdb and a table withe the name Nomi

Nomi in italian it's Names

I whant to export records "Nomi" to txt file ' c:\myfile.txt ' the output file shuld be like this


carlo,marco,pippo, .......etc
max,roberto......etc


can anyone help me
thanks

[RobDog888]

You can use the .TransferText function in Access.

Application.DoCmd.TransferText acExportDelim, , "Table1", "C:\Test.txt", True

[asamy]

thanks RobDog888 for u'r quick answer

sorry bet I forgot to say somyhing before

I use visual basic 6

[RobDog888]

Ok, well I seen you were saying export from access as if you were doing it with VBA. No worries.

You can use ADO to connect to the db and read the table into a recordset and then do a save.

'...
oRs.Save "C:\Test.txt", adPersistADTG

[asamy]

thanks RobDog888 for u'r time, but I'm new in visual basic and what u wrote for, as we saying in italy, is ARABIC ! thanks any way it was kind from u to answer me, I think taht I have to study a lot...

P.S. sorry for my bad english
have a nice time ciao

[RobDog888]

These two threads are a great place to start for learning ADO.

http://vbforums.com/showthread.php?t=349994
http://vbforums.com/showthread.php?t=416225

[asamy]

I've allreadt saw it, I have sart learning frome there u know.
I can connect ado to db and read/change/insert data to db, visual db in datagread....

but now I'm blocked here at the end of my prog. I need to export a record of table into txt or msword file, I'm in this step about 4 days I've searched everyware. maybe i need to go sleep and tomorow how knows....

thanks

[RobDog888]

But if you can do that then you should have a recordset object and just need to save its data if its populated with the needed table.

[asamy]

ok, I can get the data from the table Nomi, lets say that I got the name "marco and francesco" now from visual basic how can I make a txt file "C:\myfile.txt" and insert the names in to it??
I need to make a txt file and insert any "data" in this format
es
marco,francesco, anna,......etc

I hope that I'm clear

[elgalloloco]

You can use the .TransferText function in Access.

Application.DoCmd.TransferText acExportDelim, , "Table1", "C:\Test.txt", True

What if this was the other way around??

From a text file to a Database? I know the database must me design with at least 1 table...

[RobDog888]

es, you can just use the acImportDelim parameter to specify an import.

[asamy]

thnkes elgalloloco

lets forget the database ok
All I need is: form my app "in visual basic" to creat a txt file "c:\myfile.txt"and insert 2 value withe comma the output of myfile in this format


value1,value2

and nothing else

can I do that?

[RobDog888]

Sure, just use basic File I/O

Open "C:\Test.csv" For Output As #1
    Print #1, "Meow, meow, meow!"
Close #1

[asamy]

ohhh yes thats ok for me just one more question can I do it without the (" ")

if it is possible like this Meow, meow, meow

thanks RobDog888

[RobDog888]

Just change the file extension to a txt file. Thecsv places text qualifiers on there by default.

Open "C:\Test.txt" For Output As #1

[asamy]

hi RobDog888,
U solved my problem thanks now I can go on I wish u a good day



thanks a lot
asamy