database connection

I'm using Excel and Access 2010 and have been searching for some simple code to open and write data from an excel spreadsheet appending to a table in Access. I have already successfully defined a connection via Excel's external data query to load the table into a sheet. However, at the end of...

Hi all, I am hoping y'all can help me with something. I have several large (big enough to not make it practical to combine them) workbooks in 1 folder on a shared server. I have created a seperate workbook to pull data from these workbooks based on a "customer number" criteria. What i would...

Hello, I am very new to VBA and computer Database programming in general, so any information or guidance would be appreciated. I have got an Excel Stocklist with flieds: Article Name, Description, QTY and Tray I am hoping to upload just the QTY column to the 'JobBOSS' Database and update the...

Hello all. As always, thanks for this repository of knowledge and experience. I manage a growing retail firm that has recently expanded from a single-location to two locations and a separate warehouse. Initally I was tasked with developing a Point of Sale system that would track our inventory...

I need to return data from a database table whose name is in another table. Ex - TTT.best has only one record with the name of the best salesman and his current sales total. Database TTT has a table named for each salesman with the individual sales data. In an Excel query, I want to return...

I have a spreadsheet with following columns - User ID Age Height Body type Complexion Diet many other like this I want to create a database such that, For E.g. if someone selects age between 23 to 26 and height 5.6 to 5.9, body type as average, then it should pick all filtered data (as per...

My dear Forum Access 2007 / XP I am becoming more confident communicating with an Access Db from Excel. I have a process that works but I want to understand the differences between the different methods of connection. I have four modules that all seem to connect in different ways. What's...