0

Hi,
Pl tell me the code to copy the existing table of Access or SQL and give the new file name to it from VB6 at Run time without changing the field name.

(k. S)

4
Contributors
6
Replies
8
Views
8 Years
Discussion Span
Last Post by rm_daniweb
0

Do you have the code to open a database? Do you have the code to select what you want from the database? Do you want to keep the native database format or are you wanting to export it to something like a .CSV file? Are you looking to be able to back a database up? What code do you have? Please show us so we can help you help yourself.

0

Hi,

Which Database..? Access/MSSQL/Oracle..?

Hi,
Presently I am using Access as backend.

0

I am using code like this
Under General tab
Dim cn as new ADODB. Connection
Dim rs as new ADODB. recordset

code to Select database is
rs.open "Select * from <table name>",cn,adopenstatic, adlockoptimistic
using ACCESS as backend

0

CREATE TABLE IF NOT EXISTS newTable SELECT * FROM anotherTable WHERE yourcondition='conditionvalue'

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.