Is there a way to write data from a cell in Excel to a particular table
AND record within Access?
For example we have a database called Client.mdb and a table called
Accounts and a field in the table called Considerations. Each record
has information in the Consideration field. The current information is
pulled into Excel through a simple query. I am trying to avoid going
back and forth b/w the 2 programs. Any help would be appreciated!
Re: The best elegant solution to override 65k rows limit in a sheet ... It's not that they're essentially database applications,... >You're doing the same thing by bringing data into Excel and then you ... relative increases and decreases in rolling 3 month ... I imported the data into a new worksheet beginning in cell A1, ... (microsoft.public.excel)
Re: formatting columns ... >> I am preparing to set up a database in Access2002. ... He knows how to use Excel on a limited ... >> have the time to set up the Access database so I must do ... >> in the first cell, and then having to drap it down the ... (microsoft.public.excel.worksheet.functions)
Re: inputing survey data ... I have a similar problem as LadyZ, I too have made a database in an excel... To merge the question cell in the database to use a separate ... You could have used an online questionnaire like Survey Monkey,... (microsoft.public.excel.misc)
Re: Access to Excel ... If I call my access table "table 1" and the cell that I want to draw the ... The 2 excel forms are in seperate workbooks, when we print them they have ..."John Nurick" wrote: ... In our access database we have a set up called DR REC. ... (microsoft.public.access.externaldata)
Re: Best practice to store/manipulate Excel spreadsheet cells ... a table to store the coordinates on the image of each bookable "cell".... and would adapt well to an irregular floor plan.... is likely to be a better way of getting a "live" floor plan than Excel.... part of an event managment database.... (microsoft.public.access.formscoding)
