Thanks for the insight. Just created the transitional staging table and the append query.
The first run was not successful. Will review.
I assume that the autonumbering field will "automatically" populate when using the append query to "batch import" records.
Will the autonumbering be in...
Well, Additional information...
The text file has the following fields; DateOfService, AccountNo., LastName, FirstName
The MS Access table has the following fields; ContactId (AutoNumber), DateOfService, AccountNo., LastName, FirstName
Is it possible to import a text file into a MS Access table that has a autonumber primary key field?
Have tried several times without much success.
What is the preferred method to import to a table with a autonumber primary key field?
There are 64000 rows in Worksheet 1 and 50000 rows in Worksheet 2.
The data is sorted in the Worksheets whereby the names are not duplicated in the worksheets. For example, Worksheet 1 contain names from say "123AD" to "199DZ" and then Worksheet 2 is a continuation of the names, from say...
Have three worksheets.
Is it possible to perform a vlookup across multiple worksheets in a workbook? The objective is to populate the "FeeAmt" column in Worksheet 1 with data that resides in Worksheet 2 or Worksheet 3.
Worksheet 1 has the following columns
Name---------FeeAmt
123-AD
246-GG...
Did try both suggestions
Error message using DATE datatype is "Invalid number format model."
E.g.
TO_CHAR(CLP_ADM_HOUR_CD,'HH:MI:SS')
Error message using character string is "Invalid precision for decimal data type."
E.g.
TO_CHAR(TO_DATE(CLP_ADM_HOUR_CD,'HH24:MI:SS'),'HH:MI:SS')
Currently have a passthrough query within MS Access that is used to extract data from an Oracle database.
Select Name, AdmitHr
from Encounter
Noticed that the query results for the "AdmitHr" field appears to be in military time format, i.e. 022, 17, 024, etc.
Can anyone offer insight as to...
Well,
The sql runs fine in Sql Developer version 1.5.3 but doesn't run within MS Access 2002 as a passthrough query.
"TAG" is the alias for the table named "CMC_TAG_CLAIM ."
Maybe, I have some hidden characters considering that I copied the sql script directly from the SQL Developer pane into...
The error remains.
Reviewed the sql script once more and did take out the semicolon.
Also included a comma after each number in a series if a comma was missing such as below;
WHEN CO_STATUS IN ('42''43','45') THEN 'PEND'
WHEN CO_STATUS IN ('52','54','58') THEN 'ADJUSTED'
What am I...
Have the following Oracle query that I would like to convert to a MS Access Passthrough query but continually receive a "ORA-00911: Invalid Character" error message.
Any idea as to what the problem/resolution is?
Greatly appreciate any insight as this is taking over a hour to resolve!
SELECT...
Having trouble locating a "Missing Keyword" error in the sql below that I am using within Sql Developer to extract data from an Oracle database.
What is the problem and resolution?
Thanks in advance.
Meanwhile, I will continue to troubleshoot.
alter session set nls_date_format = 'MM/DD/YY'...
Upon reviewing this again, I am interested in reviewing columns A through K on just four worksheets and highlighting, in blue font, those cells that exceed 4.99%
Using the following vba code that I obtained from another site to conditionally format an entire row on 4 Excel worksheets - Sheet 1, Sheet 2, Sheet 3, and Sheet 4 if there is a value > 5.0% in one of the columns.
Currently, the code is set up to just search one column - column J on worksheet...
Continue to receive the ORA 00923 error upon trying to run the following sql script using Oracle 8.
Any ideas as to a solution?
What am I missing here?
SELECT
CLM.GRP_CD,
CLM.CLCL_ID,
SUM(CL.CDML_CHG_AMT),
SUM(CL.CDML_PAID_AMT),
MAX(ST.Review_Date) Review_DATE,
M.MEB_CK,
M.MEB_NAME...
Have a voluminous workbook that contains over 70 worksheets and I need to find the occurence of specific text and note the worksheet name and cell location of the text.
Can this be done?
Have tried Ctrl F but it does not work.
Additionally, is there any way to create a "control sheet" that...
Continually receive the ORA 00923 error upon trying to run
the following script via Oracle Sql Developer to extract data from Oracle database.
Error appears to be caused by the line that begins with
the subquery.
Any assistance greatly appreciated considering that after 45 minutes of review...
Will create the two queries.
It appears that a self join may not be necessary before the two queries are constructed and implemented.
When would a self join be required?
Have a single MS Access table that includes the following fields;
EmpID---BeginDt---EndDt------Name
10235---1/1/08----12/31/08---Jill Smith
10235---1/1/09----12/31/09---Jill Smith
10236---6/1/08----12/31/08---Joe Smith
10237---1/1/09----12/31/09---Jane Smith
First objective is to extract all...
Following part in an Access sql does not work - no records are displayed.
Run a query every Friday and need records that have a sign date greater than last Friday.
Any clues?
WHERE Format([Oregon_Daily].[SignDate],'MM/DD/YYYY'))>Now()-7))
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.