RE: Exporting tables into a SQL Database Table

[allyne]

Hello,

I have an Access2000 database that has a table that I want to export the data only into an SQL Database Table automatically. Is this possible? If so How? Its been a long time since I've been in access and am very very rusty.

Thanks for your help!

 

[PHV]

Can't you write an append query reading your access table and populating a linked table ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[allyne]

OPPPSSS forgot to tell you that a database will be downloaded each day from a web site to a file then the user will export the data into the SQL table. The database name will be different each day and I would like to automate this using an ODBC connection without having to create a linked table each time.