Search results

Graham, Thanks for you help on this even though we didn't manage to get it done. hope you have a good weekend and maybe see you again on here. Cheers, Phil

Hi Graham, I need to value I enter into A2 on the spreadsheet to be the part number in the Access database and for the query to pull back the description, price, etc. into adjoining fields on the spreadsheet. Any clearer??? Regards, Phil

Graham, think we're getting there on this. On pic #2 where you have entered the "equals" "xxxxx" i need this to be a cell reference, i.e A2 on the spreadsheet where I want the data to be...... Regards, Phil

try this one. sorry for the error last time

here's a compressed cut down version of the database. only got 17 lines in it whereas the live version has 91200!! Cheers, Phil

Hi there, have looked at the filters and there's not one that allows me to reference a cell in the worksheet which is what i need to do to pull the information from the database. Hope this makes sense and I look forward to hearing from you soon. Cheers, Phil

Thanks for the replies. I've looked at the data//import external data/new database query stuff and it seems to bring back all of the data in the spreadsheet. To give some more background on what I want to do..... I need to enter a value in a cell in an excel spreadsheet and for the next cell...

I have a problem getting data from Access into Excel.... We have a spreadsheet at work which we use for quoting customers. the problem is that now we have taken on board some new products the list for items is now up to 91,200 which is too many lines for a spreadsheet. I've exported all the...