Search results for query: *

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...

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 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...

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...

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...

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...

I'm trying to export a table directly from Access 2003 to a comma-delimited file (.csv) I've defined the date column type as "short date". Imagine my surprise when the resulting .csv contains a date/time stamp (mm/dd/yyyy hh:mn:ss) in that field. How do I achieve a simple mm/dd/yyyy? Regards...

This is my first time in access. Converting from one payroll system to another via Office 2003. I need to 1) Load spreadsheet data from source payroll system. (Done: I've chosen to create and populate an Access database) 2) Build .CSV files based on. but different in layout from, the Access...

To paraphrase Lou Costello "This is another fine mess I've gotten myself into!". I have a multi-tab excel spreadsheet. Each tab appears to be highly normalized and thus lends itself to import into Access Tables. However, I think I would need to add keys and set up the relationships. Since we...