Selecting a Database in Access

[Rougy]

Hi,

How would one select a database in Access?

For instance, in Excel, to select a sheet, you would write:

XLApp.Sheets("Sheet 1&quot.Select

I might be going about this bass-ackwards.

I need to dump selected data from an Access database called "history", which is in in an *.mdb file called "History", into the central SQL database.

Thanks

-----
The death of dogma is the birth of reason.

 

[sdraper]

If you are importing to SQL Server why not use DTS in the SQL server environment?

Sam

 

[Rougy]

That's all Greek to me, Sam, but I did figure out how to connect to the Access DB using ADODB.

If you have time, could you point me to a place where I could learn more about DTS?

Thanks,

Rougy

-----
The death of dogma is the birth of reason.

 

[sdraper]

Well if you have SQL Server then you, most likely, have a database administrator in charge of said SQL Server. He/she should be able to tel you if DTS(Data Transformation Services) is the best way for you to go. If you could give me a bit more background on the data you need to send to SQL maybe we could come up with a solution.

Sam

 

[Rougy]

Sam, I'm a one-man show on this one and I snuck in through the back door. I am the DBA.

I reckon I can cypher my way through this one from here on out.

Thanks for taking the time to try and help.

-----
The death of dogma is the birth of reason.

 

[Rougy]

And an FYI for anybody interested, this is what I was looking for:

cn.Open "DRIVER=Microsoft Access Driver (*.mdb);" & "DBQ=C:\VB\History.mdb;"

I didn't know I could treat an Access file the same way that I treat SQL.

Be well.

-----
The death of dogma is the birth of reason.

 

[sdraper]

OKie Dokie. IF you have more questions please post them. Myself or any one of the much brighter than me folks onhere are always happy to help.


Sam

 

[sdraper]

Wow. I doubt anyone would have guessed that's what you were looking for based on your question. Good Luck in your quest

Sam

 

[Rougy]

Hi Sam,

Yeah. See, I thought that I had to treat Access the same way that I was treating Excel, but after I found that connection string, it looks like I can treat it like SQL, and use the same Select statments and recordsets.

Adios.

-----
The death of dogma is the birth of reason.