Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: How can I fill Database with VBA on Mac?

  1. #1
    New Member
    Join Date
    Apr 2014
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default How can I fill Database with VBA on Mac?

    Hello everyone!

    I have a lot of files with tables. Data from these tables should be transferred to SQLite database. I'm coding on Mac, thus there are a lot of limitations. As a driver I use one from Actual Technologies.

    I can easily get data from DB with QueryTables. But how can I write data to DB with it? I tried making a loop with QueryTables.Add, but:
    1. It seems unreasonable to create a new QT for each row I want to write.
    2. It works badly, causing General ODBC Error 1004. Probably because it attempts to send an INSERT query while the previous one is still in work (and you can't set BackgroundQuery to False with "INSERT").

    So what's better to do about it? Can I insert/get data to/from Database without using QueryTables at all? ADO doesn't work on Mac.

    Or how can I write data to DB with QT?

    Thanks in advance!

  2. #2

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •