Recent content by zentel

My appologies, You are a genius. sorry, for some reason I overlooked your last post. It actually works for what I need. Now I need to figure out way to but this inn vba and export as a text file or possibly a *.sql file. Again thank you so much and very much appreciated.

Hello all, I have been searching, studying and learning from post from here and other places to help resolve my issue. I have been able to have this work with a code in excel and need help replicating the code to work in access. As stated in previous post, i am not good with VBA and struggling...

Thanks Plog, much appreciated. I have also been researching trying and for what if worth I did something in excel which works but I am trying replicate that in Access with no success. Please see attach image. Any help will also to have this work is access will be appreciated as well. Thank you

Thanks Plog, Please no need to apologize, I understand where you coming from. Also I am not sure if you are referring to bulk loader... one of the DBA'S I am working with had me tried that on a text file i pulled from earllier suggestion, but after the upload there was some in consistency...

Hello Plog, Is not that I have not explore those option, the sql client I am limited to right now is the sql* plus. I am guessing you understand how that will be difficult to work with aside having to put in bunch of sql statements. At least that is all I now. I came to this forum for help and...

Thank you The_Doc_Man, Your question is what is am looking for. What I was thinking off was a way to print the insert statements line by line per record, to the test file where the values contains the records of the query or table. Hope this helps. Thank you

Thanks JHB, Well, I have a query with the results as follows Col1 col2 col3 col4 col5 col6 col7 EsY ty 1 7 goo 7 no May no 4 9 try 8 yes I want to have this results of the query insert into the Values of the insert statement, then print the insert...

Please this is the code by DCrake... Dim fFile As Long Dim strFile As String Dim strString As String Dim Rs As Recordset Dim RsSql As String fFile = Freefile 'Nominate the output text file path and name strFile = "C:\FullPath\TextFileName.Txt" '***You may want to put a check in here to test...

Hi, Can someone assist me with adding a recordset data to an insert sql statement in a VBA and printing that statement to a text file I found the below code by DCrake here on access-programmers, but since i have little knowledge i am unable make the needed adjustments to achieve the desire...

Please any help still on this? I am not sure how to go about this but is it possible to have a code to go through the results of a query and use the print method to print an insert sql statements for each record into a text file. Please any help will be greatly appreciated Thank you

Thank you very much, your suggestion has peaked my interest. unfortunately i am a newbie in access so don't know where to begin. I only started learning access because of this migration project. Please can you give me a mock on your proposal this way i can have some foundation to work on...

Thanks for you feedback. Pardon me if my question is not clear, but what i want to is to be able to convert the query or table into SQL statment like below This: INSERT INTO contacts (contact_id, last_name, first_name, address) VALUES (1000, 'Smith', 'Jane', '10 Somewhere St.'); or this...

Thanks for the great response, very much appreciated. I have few questions...is append query same as insert query in access? if so i created an append query and used the suggestion you made to export the query as *.sql but it did not export the sql statement but rather the results of the append...

Thanks for the quick response. Unfortunately I can't have a direct connection with the Oracle database. The database server is being hosted by a vendor and the only connection I have been allowed so far is using an oracle sql client to query data to and from it. Thank you

Hi, I am a beginner in ms access and working on a project of moving some data in access to an oracle database. Please i need assistant on how to create an insert query from an access table and export the sql to a text file. This way i can run the sql statement that has been export into the text...