Search results for query: *

Awesome! Thanks!

Works Great! Only problem is how to I format the cells? After using the formula, I cannot format the Dollar columns as currency and the % column as percent.

I have an Excel workbook with 6 columns. I need to combine them into one cell but maintain a specific number of characters per column. Example: Name Orders Dollars MTD Ord MTD Doll % of goal Name 1 $1,000 10 $1,000,000 15% Name would need to be 8 characters no matter the...

Great Thanks!

Hello! I have a macro in Excel that I wrote. I need it pause to 10 seconds before it executes the next set of code. I am using Application.Wait Now + TimeValue("00:00:10") This works but seems to freeze the entire application. I have ODBC updates running in the background that need to run...

I wrote a VB Macro to feed data from an Excel sheet to an ActiveX Control that runs an LED sign. This Macro is on a loop. I made a button to start it, can I make one to stop it?

I tried that and it eliminates any duplicates in each column. I need to eliminate duplicates only if the Part, Mfg, and Available all match. The following SQL Query works but I need to display all the columns. SELECT DISTINCT Inventory.Part, Inventory.Available, Inventory.Mfg FROM Inventory;

I get several lists with inventory from my suppliers. I import the excel files into an access database. Multiple suppliers list the same inventory from the same manufacturer. I need a query to eliminate the duplicates. I have 5 columns: Part, MFG, Available, Vendor, Cost, Datecode, Package...

Jim, Right on target! If you have time, a short explination of the code would be helpfull so I understand it for the future. Thanks!

Hello! I have a gridview with phone call statitics for my sales dept. The 6th column is "TotalCalls". I need to change the font color to red if the number of total calls is less than 40 or to green if it is 40 or higher. I am new to ASP.net, so the simplest explanation will be appreciated...

Just a note.... I have actually used DTS to import from Excel to Excel. I needed to automatically combine 2 spreadsheets on a daily basis. It worked great!

Sorry if I confused anyone, sometimes I do that! I have an Excel spresdsheet being imported into SQL using DTS. One column has part numbers. These part numbers are alpha numeric, but some are numeric only 6- 10 digits. During the import the numeric only part numbers are not imported and left as...

Well having SQL output the Excel file as a csv file did not work. This is very frustrating. I guess I will have to convert the file to CSV by hand from excel and try again. If anybody has a better idea, please speak up!

I have it set for nvarchar(255). I found some info that this is designed behavior for SQL. Microsoft suggests saving the file as a text file and then do the import. I guess I will add a step to the DTS to do the conversion to text and then do the import.

I have tried many different "Data Types" with no luck. This is crazy! I hate Microsoft sometime! Ugh!

Hello! I have a spreadsheet that imports via DTS. It has a part number column that may contain both numbers and letters. If the part number is numeric only and over 6-8 digits long the field is left blank. I know this has something to do with the way Microsoft "predicts" the data type by what...

Sorry I took so long getting back! I used the ActiveX script and it worked great! Thanks!

I have a inventory I import daily from a Pick system via ODBC. I need to add 2 columns, Date and Source. Date being the date the import occured. Source will always be a fixed value. Can I do this with a DTS package? I am running SQL 2000 SP4. I am new to SQL so the simpler the better! Thanks!

Why would I want to spend more money on software if Exchange and Outlook can do what I need?

We are using stationary to display a banner in the email, for informational purposes, new products, current specials and User information. Now I have to load the stationary on every machine each time we change it. I have over 50 users and it is quite a task. I saw the GPO ability to specify a...