Search results for query: *

Thanks jrbarnett. Thanks for the confirmation that I stumbled into the more appropriate solution.

I've found three approaches to obtaining a count of the rows that satisfy my Microsoft 2003 jetSQL. One is to use the COUNT(*) in a standalone SQL statement using the same FROM, JOIN and WHERE criteria as the separate SQL statement that actually gets the data. Another suggests changing the SQL...

Thank you, lameid, for re-iterating my question about looking for alternatives. You have great empathy. If nothing else, I've learned not to editorialize. Still the comments are quite interesting and -- despite the blood on the floor -- I've found them quite worthwhile. I agree with JoeAtWork...

Send me your address and the name of the beverage of your choice <grin>. Seriously, this is wonderful stuff. I need to study it, bu this appears to be exactly what I was looking for on the first post. It may be too late for the current application. But this is wonderful stuff. Thank you.

PHV says ... ms-access is a desktop database, not a professional RDBMS I suspect that Andy Rooney might say "I wonder if Microsoft knows that." But based on many of the above comments, after 35 years in the business, I apparently became a dottering old fool. Am I mistaken that Microsoft...

Michael Reed says Personally - as a PROGRAMMER, I try to understand the options available and plan the work according ton (sic) those options.As a "programmer" are you in the habit of delivering systems that require your manual intervention every time the client runs your application? Skip...

Thanks folks ... I really appreciate your responses. As jkl0 points out ... One workaround is to add a new row at the top with text in it. And in the cases where I have only one column with this issue, that's what I do. But what do I do when I have multiple columns. For example, in this same...

Thank you, dhookom, Again, I apologize for giving the impression that Microsoft produced that "clearly..." message. I was editorializing in what SkipVought confirms above -- to wit: What is happening is that the import manager analyzes the data and where you nave NUMBERS, its a TILT !

Thanks Skip, By "TILT" I gather you mean that I cannot override the import manager?

Thank you. But read it again. In the source spreadsheet and in the target Access 2003 table, I've defined the cells in this column as "Text". It is Microsoft that, during the import, is apparently overriding my definition as it finds that the majority of the data is in number form (i.e...

Is there a way I can get Microsoft Access 2003 to respect the cell definitions I provide? The symptoms -- as bizarre and indictable as it would seem -- suggest that Microsoft has decided I mistakenly defined the cells as text when they are clearly numeric. Specifically, I'm importing a file...

I find it hard to believe that you can't accomplish a data migration with little more than a series of queries (action and select) Probably true, but "When the only tool you know is a hammer, ... (every problem is a nail)". Still almost every field has some operation I must inflict -- changing...

I think I'm giving my Microsoft 2003 Access application a migraine headache. I wonder (1) if "import" is a better option than "link", (2) how to handle the ADODB.Recordsheets and SQL "Opens" efficiently, and (3)whether I should re-package my single .mdb module into multiple .mdb modules. The...

Thank you. Can you recommend a microsoft SQL reference? I never would have figured these out based on my experience with other sql encounters (DB2, mySQL). And Wiley Publishing's Access 2003 Bible doesn't cover these kind of details. Thanks again! Grnadpa

In an earlier post, rac2 and PHV helped me with the SQL format example. sqlOut = "INSERT INTO tryit (myID) VALUES ('" & aEMPLID & "')" This worked fine until I got to aEMPLID valued O'Shane (i.e. apostrophe embedded in the name). I do have a function through which I run my string input. It...

So the only thing left is where to send the beverage of your choice <grin>. You're a lef-saver. Thanks!

Here is a simpler one in its entirety where I get the same err.description. The table name is "tryit" The key column name is myID, text for length 11 The other column I named "somethingElse"is text, length 5 with default value "deflt" Sub NowTryThis() Dim rsIn As New ADODB.Recordset...

The message I get in the ACCESS 2003 sub within module1 is "No value given for one or more requested parameters" I am trying to map data from externally linked excel files (EmpComp and EmpPers) to a single ACCESS 2003 table (PS_PERSONAL_DATA). the "rsIn.Open sqlIn, CurrentProject.Connection...

I think I follow most of what you recommend, Hmadyson. Thank you. I'm a little afraid of, if you'll excuse my mainframe terminology, "currency" on my main table row while I got out multiple times to different tables. I'm also mildly concerned about performance. Under this scenario, I would...

Access 2003 is new to me. I've dabbled in mySQL and PHP5. What I'm trying to bend my mind around is how to embed a query/SQL while walking my dynaset. The task is to take data from a variety of sources and map them into another format to be rendered into a comma-delimited-file. In addition, a...