Recent content by JaxtheDog

Skip, I have tried this several ways, as I said. When I cut that code from the larger Proc to give you an example of what I was doing, I didn't remove the bit you referenced--and yes, it does open correctly when the function OpenTextFile fires. Trying it various ways, I can always copy the...

Here is generally the code I am using--this is one of many iterations. I made things visible so I could see what is happening. I open the first (existing) spreadsheet and then open a second one (blank). I have also tried creaing a new one. I pastespecial from the first to the second. Color and...

I am working in Access using VBA to processes spreadsheet lines. I copy failed lines to a second spreadsheet to re turn to the user. It is working using a range of cells and pastespecial to the second excel file. However, I can't get the column width to go from the original to the second...

Thank you for the reply--and for your help! It is much appreciated

Thank you for your help--the quick reply is much appreciated. We did check the Oracle_home variable and it was missing. It is hard to say for sure, since we tried several things and could have been better testing after each, but it appears that the presence of a sqlnet.ora in the same directory...

I got a new version of Toad version 9.1, and since then I cannot connect to my Oracle databases and get the message -TNS could not resolve service name. I am using the same TNSNAMES.ORA which worked before, and it is in the right location i believe ( becos i can select the database read from...

It worked PERFECTLY! Thanks you so much for the quick--and correct--answer. I really appreciate it! Have a star. Jax

Hello, I am familiar with SQL and VB, but am new to Access. I need to update a column in a table based on a heirarchy of other field values in that same table. I can't find a syntax that works using a SQL query in Access. I have tried IIF, but it only gives me one true, false--and I need...

Thank you for the suggestions. I will try a load and timeit--and I will review the FAQs

I am new to Access although I have used Oracle and Sybase. I need to use it to import a text file containing a list of IDs with some other descriptive information. The text file will have about 800,000 rows. The import will be to a shared network drive tuned for database performance. Can anyone...

I have figured out how to acomplish this, and have some clues to what I was doing wrong. So I thought I would share them. In my original forall, I tried to load all of the eligible items into a cursor and use it in the forall statement. I could not figure out how to get that to work. Instead I...

Good Afternoon, I need some help understanding buld collections and their use in a forall statement. I want to update multiple rows in a table based on the results set of a query (cursor). A simplified example of my current statement is shown below. It's been thought several interations as I try...

Mjia, There are different versions depending on features you want. The professional Suite, for excample, has lots of DBA stuff and trace/explain plan, etc. For a try-out of the database loader, the roacle Suite one works well. Download it and answer the questions about yourself. They will...

I use TOAD (Tool for Oracle Developers) from Quest software which allows you several options to load data as well as view and query. You can download a free 30 day copy from their web site. It's worth a try, I like it. Jax

SantaMufasa, I have benefited from your posting to others, and I also want to take this opportunity to thank you for your excellent help. Your clear explanations are works of beauty! Jax