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