The image size limit has been raised to 1mb! Anything larger than that should be linked to. This is a HARD limit, please do not abuse it.
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?

pslong9pslong9 Registered User regular
edited November 2007 in Help / Advice Forum
Hi all,

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
pslong9 on
Sign In or Register to comment.