progammatically inputing data from SQL server to Access 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to set up my database so that it will automatically update its
tables and reports with new information on a daily or weekly basis. I am not
really sure how to make this work automatically, like without having to press
any buttons.

First of all I do not know how to transfer information into access from the
SQL server because I found that only access 2003 has the option for macro
actions "transfer SQL Database". Is there any other way to do it or do it
have to transfer first to excel then to access?

I also want to be able to use the IsNull function in the Conditions column
of the Macro to check to see it there is information inputted into the table.
When I do this I am getting the error “can’t find the name ‘Tbl_reasons’ you
entered in the expressionâ€. This is the name of the table and in the
expression builder I have entered: IsNull([Tbl_reasons]![Reason]).

Thanks so much
 
Lets try first and get you connected to the tables in the SQL serever
You dont beed to transfer the table to Access or from Sql to excel and then
to Access.
You just need to link the tables from SQL to your application, then all the
tables behaves as they are local tables in the application, to do so choose
link, when you get the prompt form to select the object, select first the
ODBC for sql, and then select the Sql connection you work with, now you will
be displayed with all the tables and views name to select from, choose any
table you want.
Now in access you can use this table directly for the report or use update
query to use the data and append to local tables.

Aout the isnull, can you post the code, or the SQL so we can see what you
are trying to do.
 
Back
Top