External Database

Hi This question needs extra information to answer. However an external database means a database file or service like MS Access or MS SQL Server. Just post the details of requirements or the event where you have hit this doubt to me. Read More »

Source: http://answers.yahoo.com/question/index?qid=20080204041840AATFGv0

How to Copy tables from an external database?

Hello meciab, Example: docmd.TransferDatabase acImport,,"c:\mydatabase.mdb ",acTable,"tblmytable","tblNewname",false Look at Transferdatabase in Help for all the options. Pete Read More »

Source: http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q...

What is the VBA to import a text file to external database?

If you want to transfer data to an external database from your Access application you've got 2 choices: 1. Write the import routine outside of the Access application OR 2. Create link tables inside your Access application and append the A... Read More »

Source: http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q...

How to Link a table from external Database?

Why do you need to link it? If your going to do the linking in your sql statements you could.... dim conn as adodb.connection set conn = new adodb.connection conn.connectionstring = ..... conn.open dim sql sql = your sql with the join dim ... Read More »

Source: http://www.experts-exchange.com/Q_20169357.htm

How to change an Excel 2003 external database query

I see you problem now. do you have the latest SP for XP installed? perhaps changing the connection string programmatically might help.: http://www.dicks-clicks.com/excel/ExternalData3.htm#CreateVBA Othterwise I cannot figure a workaround fo... Read More »

Source: http://www.experts-exchange.com/Q_21473392.htm

How can I close the external database that was linked to?

Instead of creating a link and then deleting the link can you just use DoCmd.Transferdatabase to move your data? Read More »

Source: http://www.experts-exchange.com/Q_23112012.htm