Ok, I have an application that is using a back end of MS Access...I have another application that needs to get some of the data in the Access db but it is only SQL compatible.
So...how do I set up an ODBC connection that will pull data from the Access db and write it out to a SQL db? This data needs to be updated hourly...
Thanks for your assistance!
posted by keep it tight
on Mar 14, 2013 -
Need help setting up a simple Access database. I'm trying to reconcile a bunch of inventory, which is all recorded in multiple Excel spreadsheets. I want to import all the Excel files into an Access database so I can match them up all at the same time. [more inside]
posted by smoothvirus
on Feb 22, 2012 -
MS Access Database Relationship Help. I am relatively new user of MS Access and need to figure out the ideal or proper relationship between the tables I have created for multiple company's financial statements that will provide the most flexibility when viewing and comparing the financial statements. [more inside]
posted by otto42
on Jul 10, 2011 -
[MSAccess Filter] HELP! I have been thrust into Access with no understanding of how it works beyond a 10-minute "use this" and "do that" session. Now I think I inadvertently deleted a couple of essential "forms." Can I get them back? Or rebuild them? I know the data must still be in there, but I don't know how to display it. [more inside]
posted by AnOrigamiLife
on Sep 16, 2010 -
I am wanting to enjoy some outdoor exploration this year in Washington state. The catch is, I have multiple sclerosis and my ability to walk is severely hampered (I can walk short distances- maybe about a city block or 2 at a time, sometimes I need a cane, but not wheelchair bound). Where should I go? [more inside]
posted by evilcupcakes
on Apr 21, 2010 -
Access Field question: On a linked ODBC table, I have part number information in a MEMO field, in this format: xx-xxx-xxxx. I would like to make this a TEXT field so that I can link it to another ITEM field that is associated with cost data. How can I do this in a query?
posted by strangelove
on Oct 21, 2006 -
I am wondering what the (free/cheap) options for uniting a database to templates for printing. Specifically I am worried about the ease of populating these templates, and how I could use regular sql queries to produce, for example, three invoices/page with addresses in the proper location for envelopes. [more inside]
posted by shownomercy
on Aug 4, 2006 -
How can I manage my databases that are exploding in size? Can I run SQL Server on my laptop? [more inside]
posted by benjh
on Dec 9, 2005 -