Recent content by hsingh1981

Hi all, I have a problem, I can open an excel sheet and retrieve a paticular cell data and store it to my table. How do i tell it to go through each cell and move down and store it excel table? eg. a9 a10 a11 and retrieve the data in each cell and save it to table? This is what i got so far...

Hi Everyone, I'm having trouble or finding an easy way to update my datagrid back to the sql table 2005. I can pull the data from sql to datagrid....but when i change the figures in datagrid....i would like it to update the sql table afterwards? Could someone give me an example? This is how i...

The row value in excel does change. Its the column I that remains constant. The Move next goes through each KPI_ID and get the relevant value from the field "MaxAllowTarget". It then goes to excel and places it in the relevant cell In excel Cell I4 is 74% I42 is 95% I43 is 90% For some...

thankyou for replying Tried that and still its not getting the value and placing it on the excel sheet. The other values does appear?

ok kind of sussed it out but can't seem to fill the first records. It gets the other records but not the first? :s Dim db As DAO.Database Dim rs As DAO.Recordset Set db = CurrentDb Set rs = db.OpenRecordset("Temp_KPIData", dbOpenSnapshot) 'Open a Excel and move to "source data sheet" Dim...

Hi all, I have this table which collects certain data table name "temp_KPIData". I can open the table and copy the first row field to the excel sheet. My code for this is this: Dim db As DAO.Database Dim rs As DAO.Recordset Set db = CurrentDb Set rs = db.OpenRecordset("Temp_KPIData"...

Am such muppet....almost there too. Many thanks for your reply.

Hi all, i have several excel sheets in my folder. I tell ms access database to open each file and copy the data in to the access table. This only works for the first file...i can't seem to copy the data and append to the table. I seem to going wrong somewhere. Could some one have a look and see...

sorry was little presumptious....that did work. Many thanks for your help...this is going to really help in the next stage of my query.

That doesn't work either. Any other solutions?

Many thanks for your replies I've tried both solutions and i probably haven't explained myself as clear enough. Here's what my old sql code looks like i've highlighted in red what i like to change: TRANSFORM Count(waitxx.PAT_NO) AS CountOfPAT_NO SELECT IIf([EXP_OP_CD] Like...

Hi all i have this query and in the criteria i have put this Like "M30*" Or Like "M77*" Or Like "E36*" Or Like "J43*" Or "Q189" Or Like "T43*" Or Like "W87*" Or Like "W88*" Or Like "E51*" i've changed it to a.... look up table which uses a in (select ....statement eg In (SELECT opcodes FROM...

Hi Everyone, Is it possible to use a look up table in the Select IIF statement. I have reference table which contains the field OPLines. In that i have the following data K572,K618, K636 etc. look up table is like this: OPCodes OPLines K491 C27 K572 C07 K582 C07 K618 C19 K636 C24 What i'm...

Hi All, I can link to text file as table in ms access. The problem am getting is that the date comes up with an date error: #Num! #Num! #Num! #Num! #Num! #Num!etc in the date fields. The format of the date is yyyymmdd e.g 20081106 in the text file. i've seen another database that has link...

Hi everyone, I thought i posted this question before, but my computer crashed soon after. So my apologies if i have. My question really is....I know how to show null values by using the criteria is "is Null". My problem is i have several fields in the database (about 15) where i would like to...