Recent content by kbverizon

My table A has roughly 1.2 million but I only need to pull out a couple thousand at a time which will relate to the couple thousand rows in my Table B

The issue that I have is my ole db source connection for TableA points to Server A and my data for table B is on Server B. My ole db source connection can't see the data that exists on Server B. If I was using straight sql commands I would setup an odbc connection and use some sort of...

Ok here's my issue: I have two connections setup one with my source and one with my destination. My source connection for simplistic sake has Table A and part of an earlier process I brought in Table B which now sits in my destination connection. The values of each are as follows: Table A...

I could ODBC to the database and have access create the files but the number of records that I would be running through would take forever in access. This other application is more suitable for handling the larger number of records. I actually was toying around with having access launch the...

Hi, I have reports that I run every morning that take a csv file, output an excel spreadsheet to a network drive then sends an email to the users letting them know the file is ready. Unfortunately, I am unable to automate the entire process because there is another application (showcase...

Perfect!!! You guys rock!!!!

I have a database that pulls data from a csv file and conducts some calculations. The csv file is updated on a Sunday every week. My database is automated to the point where I just have to hit a button and everything else happens for me. I would like to have the database open...