Search results for query: *

We have databases created in Access 2003 (using 2000 file format) which had several Import Specifications in each db. We converted a copy of the database to 2007. When we import a CSV file (clicking Open, and locating the CSV file) and click Advanced, the Import Specification window is empty...

Thanks, Remou. That works perfectly!

I have a csv file I have imported into Access. All fields are TEXT. I need to limit the list to only records that have Alpha characters in 'Field5'. The values in 'Field5' contain a mixture of alpha/numeric characters. for example: 021577560 200812345 12201992JW 0002244 09151975AD In the above...

This issue is resolved. We did the following steps: 1. BACKUP LOG databasename WITH TRUNCATE_ONLY at this point the log file size on disk was shrunk from 20G to about 3G 2. dbcc shrinkfile (dbname_log,2) After running the dbcc shrinkfile cmd we still did receive the message that "Unable to...

Hi, I have read many posts on this subject including thread183-430515 but am still confused. (new to SQL Admin) using SQL 2000. We have a transaction log that is 20G, leaving only 3.4g free space on the server. the data file is about 225MB and the Index file is about 245MB. We have done a...

Hello, I've seen some posts about this subject, but seem to talk about submitting email, etc. We are simply trying to open an image file on a network drive (may be a tif or pdf file). Both errors below occur before the hyperlink will open the image on a network drive. Is there a setting in...

We are Importing from iSeries AS400 to SQL server 2005 using OLE DB and SQL 2005 Import and Export Wizard. The wizard executes and imports 49588 records then fails with the following error: "Error 0xc020901c: Data Flow Task: There was an error with output column "JE103A" (161) on output 'OLE DB...

SantaMufasa.. Pls disregard my last post. I realized that I had an extra line of code for the actual_finish_date YYYY. I have removed that and I was able to create the view! I'm closing the post as resolved. If I find a problem after checking it I'll repost. thank you!!!

Hi SantaMufasa! Well... it's almost there! I've listed 3 items: #1 (your code) works... This code does not use aliases and selects directly from the sa_work_order_task table. "select to_char(actual_finish_date,'yyyymmdd')actual_finish_date...

Hello, I am attempting to group transactions by month. However we are on a fiscal year with October being Period 1. I'm a beginner when it comes to Oracle so please bear with me. :-) I'm using the following code, which groups and handles the months correctly, making OCT period 01. However it...

George, Thanks! I've changed Query Analyzer Max characters value and now i see values for Amenities. i guess these are Right Justified, maybe?? Can I change the value in the field in some way in Query Analyzer like I can in SQL Enterprise? When I go back to Enterprise I still see the blank...

Please bear with me.. a little new to some SQL db stuff,,, I have a Description field char 500. one record contains the following - and it shows up in the query: "Rosemeade Swim Complex includes a 50-meter Olympic size pool with a 25-meter short course, separate diving well, training pool and...

We have a table containing several Char type fields. Two of these fields 'appear' to be empty when viewed through query with a Select * from tblMeetingRooms. However when including a WHERE clause on that field i.e. WHERE (strAmenities like '2 chairs. Table.%') it pulls the record. And when...

that's what I had in the beginning I believe (see my first post), except i have " and you have ' for the quotes. Am I missing something from your last suggestion? We're having trouble with those records that basically do not have a time portion to the date value.... and so far it seems that I...

Tried the Where CDate.... Copied and modified your suggestion, changing "theDatetme field" to actual_finish_date Now getting "Expression is typed incorrectly or is too complex to be evaluated". here is my query grid for date: Field line: CDate(CLng([actual_finish_date])) criteria line...

Now I am missing the records with the full timestamp of hh:mm:ss AM. And it appears that I am missing a few of the ones without the timestamp, although I am not positive about that.

I have an Oracle 9i database with Access 2003 front end for reporting. I have a query that selects a prompted date range, but I am missing records. Here's an excerpt from Toad: DATE 2/2/2007 2/2/2007 09:15:22 AM 2/2/2007 12:22:03 AM 2/2/2007 From the list above, my query will pull record 2 &...

ok, but why does the following not work? Format([SYNERGEN_SA_WORK_ORDER_TASK]![ACTUAL_FINISH_DATE],"mm-dd-yyyy") with Criteria: >=Format([enter the date], "mm-dd-yyyy") when the date field contains: 1/31/2007 3:30:00 PM but setting it up as "yyyy-mm-dd" and then entering at the...

Got it! ok, one last question (I hope) on this subject. I've tried to find rationale for the format()"yyyy-mm-dd" as opposed to format ()"mm-dd-yyyy" but no success, although changing my format statement to the "mm-dd-yyyy" definitely does not work... I pull data from 2006. My actual data is...

oh!! it was using the "/" that caused the problem, when I changed it to "-" it works. I want the final query to use a parameter prompt... I'd like the user to be able to enter the date prompts as Beg date 01/01/2007 and End date 01/31/2007. Do I need to change the Format statement in the...