Recent content by mdlaugh1

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