1 - I would like to import tables from access to the sql server 2005. Someone can tell me which way is the fastest ans easiest?

2 - In access i would rather want to build a Form ("Formulário") than a simple consult. But in my form i want a consult inside. Is it possible?

Thanks

Fabio Tavares

O covinhoOo!

1) Rightclick the table, Export. Use an ODBC connection and off you go.
Or maybe you can use the data transfer meganism with SQL server?

2) a consult?? What do you mean?

Could have a look at the upsizing wizard in access.

Ok... i think i'm done! :cool: Thank u all! The "consult" i think that it was an misunderstanding. Sorry!

Thank u by the way!