How Can I to convert a variable from Access to SQL Server?

[omauri]

How Can I to convert a variable from SQL Server to Access?

Variable is for example:

In SQL SERVER:

Declare @Ids as Int

In Access (Visual Basic For Applications):

Dim Ids As integer

I need to work with a input value from Access, and this value executes a stored Procedure.

Excuse me, but my english is very bad!!!! Thanks.

 

[tlbroadbent]

The SQL Syntax for declaring a variable is ...

Declare @varname <data type>

Example: Declare @Ids Int

Is this what you needed to know or do you seek more information? I'm unclear about the question. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains &quot;Suggestions for Getting Quick and Appropriate Answers&quot; to your questions.

 

[cmmrfrds]

One thing to be aware of is that data types can be different number of bytes in Access. Use a Long in Access.

Access integer 2 bytes 32 thousand
Sql server int 4 bytes 2.47 billion