Search results for query: *

actually, that seems to have worked (the indexing and removing the trim). i import the RHMF table from a flat ascii file, do you know, if there is a way, in code, to programmatically set a field to Indexed (Duplicates OK)?

I am running what would seem to me as a relatively simple query. But Access hangs up (showing two-squares on the progress bar) and sits there. I have left it all night. No change. Here is the SQL: SELECT RHMF.ID_1, MEMBER.ID_2 INTO RHMF_Out FROM RHMF LEFT JOIN MEMBER ON trim(RHMF.ID_1) =...

Assuming I want to keep it within the DTS ... I seem to be having difficulties with the source directory path. How should I have it entered? IP? or //+IP or ??

I need to incorporate an FTP task into my DTSPackage which will FTP a file FROM a unix box onto a Windows directory. Is this possible with the File Transfer Protocol Task in SQLServer DTS? Thanks in advance.

I have a blank database into which I would like to import a table from another database. The other database is password protected, which is fine, I have the password. My issue is that I wish to place this import action into a macro ... Is there the provision in the macro design to enable the...

I have a report template that basically positions table data on a report in the format of a payroll check. Since all checks print on the same check stock, once the elements are aligned on the report, I should not have to worry about it. The issue I am seeing is that all the checks are fine...

I have a textfile that contains about 60,000 fixed width records (50-bytes). With VB, I need to open the file and remove the CRLFs so that I effectively have one long byte-stream (we are looking at about 3 MILLION characters). I can open the file and read/write, etc. but can anyone tell me the...

I think the FindFirst method will work, thanks both of you for your help.

Not really because, I have update, append, delete actions to do to a record depending on whether it is found or not.

I have two recordsets open in Access. I want to cycle through the IDs in the first rs, and trying to determine if they exist in the second rs. Is there a function for doing a search or will i have to just cycle through the records in the second rs, too? This is what I currently have: Set...

In my DTSPackage, I have an Excel to SQLServer transformation. The Excel component specifically identifies the Excel workbook to be used. However, this is a soft source in that the file name changes month to month. How can I handle this in the DTS since the Excel module requires me to...

Well, not sure if it will. I my source is actually a spreadsheet, not a database. Do I have to create a DSN pointing to the spreadsheet and then create the query that way?

Is there a way that I can treat a worksheet in Excel like a database table and then query it? For example, I have two worksheets in a workbook. wksA and wksB. In wksA(A1) i want to insert a count of the number of records in wksB that have the value '01' in the LOCATION column and the value...

Thanks to all for your great suggestions.

I need to have the following SQL round the result to the nearest integer: SELECT v_MASTER_FACTOR.FACTOR * CAST(COUNT(Parts.PartsID) AS decimal(9)) AS intResult Currently it is returning 0.9999999999, I need this to show 1, etc. Thanks in advance.

Thanks. Perfect!

Thanks to all for your invaluable input. Much appreciated.

I am trying to do alter a table (using a RunSQL statement within a VBA Module). All I want to do is to add a column at the beginning of the table named 'ID' and set its datatype to be AutoNumber. My statement is as follows: ALTER TABLE tblANCILLARY ADD COLUMN [ID] AUTONUMBER It appears...

In QueryAnalyzer I have the following simple statement: SELECT SUPPLIER.SUPPLIER_ID, PARTS.PARTS_ID FROM SUPPLIER INNER JOIN PARTS ON SUPPLIER.SUPPLIER_ID = PARTS.SUPPLIER_ID GROUP BY PARTS.PARTS_ID, SUPPLIER.SUPPLIER_ID HAVING (SUPPLIER.SUPPLIER_ID = 1020) This returns the...

YEAH, i THINK THAT WAS PART OF THE PROBLEM. I EXPORTED THE EXCEL AS A CSV, REIMPORTED THAT TO ACCESS. ACCESS DID WANT TO CHANGE THE TAXID AND PHONE FIELDS TO LONG-INTS, I JUST SWITCHED THIS TO TEXT AND ALL APPEARS WELL. UNTIL THE NEXT QUIRK. THANKS FOR YOUR RESPONSE.