Parameter dialog box pops up

[Clement]

Whenever I open the "Members" Table, Access prompts me for a parameter value;
a dialog box pops up that says "Enter Parameter Value". I dont recall
creating any parameters for the Table. Its doing the same with my Append
Query; whenever I try to run the Append Query, Access asks for a parameter
value. I simply want to run the Append Query to copy the fields (according to
the SQL in my query box) into the Members Table.
How do I prevent the Parameter box from popping up?

 

[Allen Browne]

Parameters relate only to queries, not to tables.

When you view the data in the table, do you have any fields that show as
combo boxes? If so, the combo could have a query statement as its RowSource
property, and the parameter could be coming from there.

It that is the case, you could fix the RowSource statement, or you might
prefer to switch the DisplayControl back to a text box. See:
The Evils of Lookup Fields in Tables
at:
http://www.mvps.org/access/lookupfields.htm

 

[Clement]

I got the tables fixed somehow; I deleted those Append queries and removed
the subdatasheets in the Tables. (im thinking removing those queries resolved
the problem of my pop up dialog box ...and yes I was equally perplexed to see
a Parameter dialog box upon opening a Table. For a query yes it makes sense).

Anyway I still need to solve my main problem. Here it is:
I need to update my Access database from an Excel list. (The fields in the
DB and Excel are identical....I am creating the DB from the list). Now I will
be recieving a list from time to time and I need to transfer this new infor
into the Access DB.

I suppose I should export the Excel list into a new TableN in my Access DB
and work from there. The question is how do I append each field from TableN
into their respective tables? (The only solution I have so far is create an
append query for each table from my TableN and run them separately).
How can I make this process (updating my tables from the List) better??

 

[Allen Browne]

Please ask this as a new question (if you have not already done so.)

Databases are very different to spreadsheets. Lots of tables with the same
structure is not the way to design a database.

 

[Clement]

Allow me to clarify; I have TableA, TableB, TableC, in Access. They are
designed and related appropiately. Each field in my Excel spreadsheet has a
corresponding field with the same data type that matches in my Access DB.
How can I update my TablesA, B, C with new data in the spreadsheet?
Do I import the spreadsheet into a new Table (say TableN) and then create
append queries from that new Table??

 

[nanne]

Hi

I use the following method, which is working well.
The fieldnames in Access are exact the same as the fieldnames in Excel. they
are in the first row of the spreadsheet.
Then I use GET EXTERNAL DATE-> Import
and select the Access-table to update.
very easy
success

Nanne

 

[Clement]

I dont have a problem updating just one table in Access. My problem is
updating multiple tables at the SAME time. For example updating TableA,
TableB, TableC and TableD in Access using the Excel information.
Now I can import the Excel data into a new Table in Access say TableN, but
then how do I go from here i.e using TableN to update Tables A, B, C, & D all
at once?