Our new Indie Games subforum is now open for business in G&T. Go and check it out, you might land a code for a free game. If you're developing an indie game and want to post about it, follow these directions
. If you don't, he'll break your legs! Hahaha! Seriously though.
Our rules have been updated and given their own forum
. Go and look at them! They are nice, and there may be new ones that you didn't know about! Hooray for rules! Hooray for The System! Hooray for Conforming!
Access queries using Excel data?
I'm currently trying to run a lot of queries on a large database of driving simulation data. I have the query set up such that I have to manually enter in the driver ID, and the times that I want to look at. These values are coming from an Excel spreadsheet that I've set up. What I'd like to do is to somehow run a script that would grab the IDs and times from the Excel sheet, use them in the Access query, and then copy the data from the query back into Excel. However, I'm not familiar enough with VB 6 or VBA commands for Microsoft Access to do this. Can anyone provide any help or provide a link where I can learn how to do this? It would help me out tremendously.
EDIT: Solved, my boss has code that facilitates most of this. Would have been nice had he mentioned that when I first brought up the issue.
3DS FC: 0817-3759-2788