Search results

  1. B

    Move Query data from one DB to another?

    Actually, I'm not sure how I'm supposed to email you...:confused: I can't find your email addy, and also when I click to email you from your profile I don't see a way to attach a file. ? Thanks, Brian
  2. B

    Move Query data from one DB to another?

    OK, I will email you the files. When you say "disconnect" do you mean discrepancy? The files shouldn't really be connected. Also, I should warn you that I am sending you 4 files. Our data is stored in a pair of databases: dis4.mdb (which is linked to) dis4data.mdb. I will explain more in a...
  3. B

    Move Query data from one DB to another?

    They are copies of each other. I'm just wondering: Once I have moved the data into the database with Visual Basic, how can I "run" the query or get the query to "run" it's SQL code. I can email you the databases if you think that would help. One with data AND "entries" in the query, and one...
  4. B

    Move Query data from one DB to another?

    When I said this: "When I click on the crosstab query in a clean database (a database that hasn't been used to collect data yet) there is nothing in the query (except of course the SQL code). " I was just trying to explain what I meant by "entries." Thanks, Brian
  5. B

    Move Query data from one DB to another?

    I have lots of data in the database. I moved all that over from within Visual Basic. But, nothing comes up in the crosstab query once I move it. The old database has *data* in the tables AND *entries* in the query. The new database has *data* in the tables AND NO *entries* in the query? Does...
  6. B

    Move Query data from one DB to another?

    No problem. When I click on the crosstab query in a clean database (a database that hasn't been used to collect data yet) there is nothing in the query (except of course the SQL code). When I click on a crostab query in a database used to collect data, there are columns and rows of *numbers* (...
  7. B

    Move Query data from one DB to another?

    Thank you for your reply! Also, I do appreciate *simple* explanations, if you get my drift. Ok, basically I have a VB program designed to merge data from one slave DB to another master DB (both with the same structure, and they both contain data). This is so that our clients (who use the...
  8. B

    Move Query data from one DB to another?

    Hello all! :rolleyes: I have two databases and both are exact copies. They both have a crosstab query. One of the queries has data in it. Is there a way, from within Visual Basic 6.0, to quickly move the data? Or, is there a way, from within Visual Basic 6.0, to simply move the entire...
  9. B

    Move Query Data from DB to DB

    Hello all! :rolleyes: I have two databases and both are exact copies. They both have a crosstab query. One of the queries has data in it. Is there a way, from within Visual Basic 6.0, to quickly move the data? Or, is there a way, from within Visual Basic 6.0, to simply move the entire...
Back
Top Bottom