Search results for query: *

Have you used the import wizard?

Have you tried using the Add-In manager? It might help you out.

I believe so Beren1h... I still think he will need an IF...ELSE statement to accomplish this. I miss stuff all the time...hehehe : )

Everything you said is right...I completed all projects and even completed this one two different times but it wasn't what he wanted. As for posting....I just needed the help so bad and thought that if I posted in two different forums I would have a better chance for a response. I thank you for...

Looks like to me you need an IF....Else statement?

A little bit more details as to what you are trying to do with this code....

I just want to say thank you ...you have helped me lots of times with my codes....I got noone else to respond except you...THANKS!!! Thumbs up to you hun!!!

Thank you very much for your help...I have it working now! All I did was take out the word TRUE in this line of code: Set dbsProjectcsv = wrkJet.OpenDatabase("C:\Projectcsv.mdb", True) You have helped me before so I still vote for you...A big thumbs up!! Tammy, Indiana

I am trying to populate the current database with this code I have...I get the error that the database is already open. It is open in code form not table form....I need to populate it with the records of my .csv file. It worked yesterday but not today....why? Here is my code: Option Compare...

There isn't an .ldb file. Can you do this code within the database your currently working in? I have the database open and working within the module section of this database. Do I still have to use the line Set dbsProjectcsv = wrkJet.OpenDatabase("C:\Projectcsv.mdb", True)? If I don't...

I am trying to populate the current database with this code I have...I get the error that the database is already open. It is open in code form not table form....I need to populate it with the records of my .csv file. It worked yesterday but not today....why? Here is my code: Option Compare...

Can you give a sample of the code you are using??? Tammy, Indiana

Thank you very much!!!!!!!!!!!!!!!!

Here ya go...just replace with your file name DoCmd.TransferText acExportDelim, "Standard Output", _ "External Report", "C:\Txtfiles\April.doc" (If you need more help here is a copy of the info from the help file: The TransferText method carries out the...

Thank you impulse!!!

Try putting the loop before your close #2

Thaqnk you all....I have finally figured it out!!! Thank you all who have helped me!!! Tammy Indiana

That might help me if you put the names of my files in place of yours....hehehe.....my database name is Projectcsv.mdb and my files name is project.csv is there any more help you can give me?

You can use the DoCommand to transfer your text file.

I am not getting any erors....I am trying to populate my database with this .csv file and the database is still empty but the immediate window prints the values...why isn't the csv populateing my database? The database is still empty.