Search results for query: *

Hi 2 or 3 years ago I created my first SSIS package in SQL2008, upgrading SQL2000 DTS packages. I knew little of ETL at the time (I'm not much better now!) When I was doing this everything fell at the first hurdle - ie importing some data from a csv file. There were numerous errors and when...

hi i'm trying to use the code below to copy data from a sql (2008 r2) table to multiple sheets in excel 2003 - there are currently c420000 records, expanding at around 1000 a week. this is the requirement, i have no option to use access or later versions of excel for the output. i have been...

hi i think i'm going mad! i've just set up a new home pc with windows7 pro (64bit) having loaded office 2003 i then copied my 'old' excel11.xlb file over to the new machine. when i open it it retains the customisation i'm used to but after closing it and opening excel from the programs menu it...

hi i know i'm using the word mask (in the subject) in not quite the right context here but... in access 2003 i would like to exclude a set of records from a query but can't quite get my head around what kind of criteria i need to use. the format of the values to exclude is consistent and...

hi I’m developing a system to import data from a total of 96 spreadsheets into 3 tables in access, ie 32 spreadsheets into each table. giving the end users access is not an option as it is not a permitted application on the network and users will change from day to day. I’m not an expert when...

hi i'm creating a tool that imports data from nearly 100 'input' spreadsheets accross a network. the import process works fine but there are occasionally import error tables created. is there a way of checking at the end of each set of imports whether a import error table or tables has been...

hi i'm not too hot on access vba (or access in general) but is there a way to identify the location of the active database? basically the access equivalent to excel's thisworkbook.path thanks! ;-) If a man says something and there are no women there to hear him, is he still wrong? [ponder]...

Hi I've been asked to produce a report based on a set of data. the solution lies in creating a pivot table (or multiple tables) and a chart. The data consists of, amongst other things, the date, a unique id, and a department name. the basis of the requirement is to report on the count of id...

Does anybody know why the following code fails when the active sheet is a Chart sheet. There are no chart objects (other than the chart itself) selected. ActiveWorkbook.Names.Add Name:="Data_Full", _ RefersTo:="=RawData!" & Range(Cells(1, 1), Cells(lRow, LAST_DATA_COL)).Address error is...

Hi I'm no Access expert so please bear with me on this! I have a create table query that merges data from 5 other tables into a single source. I now need to update the new table (I have the update query) immediately after it is created. The update data doesn't fit nicely into any of the...

OK, I'm hoping this forum is more appropriate to this than the Office forum. I'm trying to set up a spreadsheet to import data from a query in an Access database. The query simply extracts different data elements from 5 tables that will form the basis of a paybill model. Using xl and Access...

Hi all I'm using sumproduct to find the total number of people who meet certain criteria in a pay model. The following works perfectly =SUMPRODUCT((Band=A4)*(Range=B4)*(FT_Sal>=B19)*(FT_Sal<=B20)) where Band, Range & FT_Sal are all named ranges which are (currently) 1 column by 500 rows...

Hi All! Am I just being dense/stupid or does Find not work when in a function? The background is that I need to be able to calculate the median value of a cells depending on a criteria (well 2 actually!) The ideal function would be DMEDIAN but it doesn't exist in xl97!! So the following is...

I've looked through many sites for what I thought would be an easy thing to find but it seems it isn't so common! Plenty on how to add, change etc apps in system tray but not list. So, is it possible to list applications currently in the system tray (visible or not) inluding where the target...

Hi all This isn't really a life or death situation. My original question was going to be:- why does this work =IF(ISNA(AS2),AM2*(1+Uplift2),IF(AS2=0,AM2*(1+Uplift2),AS2)) and this doesn't (generates #N/A error) =IF(OR(AS2=0,ISNA(AS2)),AM2*(1+Uplift2),AS2) But just before posting I checked the...

Hi Not sure if this should be in here or if the problem lies with IE. On my home laptop I'm set up as Administrator and others as Limited users. However the limited users can't log into their hotmail accounts. I can log into a hotmail account and if I change the account type to admin the...

Morning All! I'm trying to create a Medians field in a pivot table of salary data using a formula The data is broken down by grade from fairly large data set and shows head count and mean. I'm trying to use a formula for the median value but keep ending up with sum of the calculated field...

Hi All A Strange occurance... I'm getting an error message as follows "Cannot Open MS Excel 97 Add-In for editing. Please edit the source doc instead" The background:- I have a file which requires that the Analysis Toolpak is installed but I have (stangely) come up against some resistance to...

Hi All I'm almost afraid to ask but I really do think I'm going mad!! I'm protecting a worksheet (xl97, SR2) using UserInerfaceOnly, with relevant cells locked and unlocked but once data has been entered the sheet becomes unprotected. This even happens with a password. I want the protection...

Hi All Using xl97(sr2) on NT4(sp6) I'm trying to enter text onto 2 (or more) lines in one cell. Normally SHIFT+ENTER does the job but it isn't working here! I end up just moving to the cell above!!! Anyone ever seen this "feature" before or am I just luck? ;-) If a man says something and...