Inputting data from a form into a linked table

[Bill Sublette]

Good Morning All.

I know this is probably avery simple thing to do, but I'm not too familiar with Access. Some of you have probably read other posts I have created trying to get Excel to do things it just really wasn't designed to do so I decided to bypass that mess and create an Access database. Here's the issue:

I have a linked Excel table in my Access database. It is currently blank and ready for the data to be inputted. I also have a table built for the exact information I would like to be in the Excel Spreadsheet along with tow other tables for the Combo Box option. What I need is to know if I need to build a form off of the linked Excel Spreadsheet (because I do want the Combo Box option) or should I build a form off of the table I created. I tried to build a form off of the Excel Table and I couldn't input any information. If I do use the table option, how do I get the data from there and into my linked Excel Spreadsheet? I need the ability to choose from a dropdown as the field for Code ID is very specific in what I need and 871 give or take Activities long.

To restate the question or issue:

With a linked (and blank) Excel file and the need to use a Combo Box, how do I get data into the linked Table or how do I get the data from Table1(which has the dropdown feature and has the same info I need for my Excel Table) into my linked Spreadsheet?

I think I said all of that right. Anyways... Thatnks for the assistance!

[NeoPa]

Bill, I'm struggling to understand your question (I know. You've obviously tried to be lay it all out clearly). This is maybe because you're trying to throw two questions into the mix and there are no clear boundaries between the two (Two questions should never be asked in the same thread. This causes more complications than simply the confusion in this one).

All I understand from this (ignoring the second part of the question which doesn't appear to live here) is that you are trying to populate a linked Excel table from within your Access database. I would say that generally, this is straightforward . There may be issues in this case which confuse the matter, but if so we don't have a clear handle on what they are. Generally though, using the form wizard on the linked table should help you to create a form which enables populating and updating of this table. If this isn't working for you, I would interpret that to mean that you have taken a mis-step somewhere along the line. I can't take this any further without knowing more details of your situation. I'm not even in a good position to list the details I would need at this point I'm afraid. I know this is all quite new for you, so I sympathise with your predicament, but do what you can to explain what's happened so far for us to be more help. Alternatively, try again using my brief instructions above and see what goes wrong where.