Search results

Thank you a Union query was just what I needed.

My bad I accidently posted the same one twice :/ Anyway I'll take a look at your recommendations and see if that will achive what I am looking for.

I am trying to compare two queries data and show if the records match and the records that dont match in the output but grouping on if they match. For instance: (Field values are deliniated by the ,) Query 1: 11, NWP, AO, 5 11, NWP, A1, 2 11, NWP, A2, 7 Query 2: 11, NWP, AO, 5 11, NWP, A2, 7...

It's mainly because of the speed between your computer and the sharepoint site. Sharepoint is a nice idea but has its flaws as well. If I were you I would split the database into a front end and a back end on your network then you could setup permissions for other's to view/import data as well...

Changes are in red. Function BrowseFile(Optional strFilter As String) As Variant Dim fdg As FileDialog, vrtSelectedItem As Variant Dim V() As Variant ReDim V(1 To 100) Dim i As Long Set fdg = Application.FileDialog(msoFileDialogFilePicker) If strFilter <> "" Then fdg.Filters.Clear...

That is an interesting way of doing it. Thank you for the reference. I'll test the theory and give it a go. Thanks Again :D

Alright well here is one of the functions that takes the longest time. It takes 34 minutes for this function alone. Thanks for the help. Function ImportTraining(strFile As String) Dim xlsApp As Excel.Application, xlsWorkbook As Excel.Workbook, xlsSheet As Excel.Worksheet Dim db As Database...

I am importing a huge amount of excel data somewhere in the 500 thousand rows that is being exported from quite a few servers. The current process I have written using vba takes roughly almost 1 hour and 30 minutes to import. Now doing it this way I am normalizing the data as well as pulling it...

As for the extracting of the data from zip files I was working on it but I have some big projects I have to get out of the way before I can finish it. I had it extracting the first zip then was working on the second zip files inside but it needs more work. Anyway catcha later

That's actually a simple fix. All you need to do is change the step number from 1 to 2. Here is the modifed piece of code highlighted in red where you need to change it. Function GetDataFromExcelSheets(lSheetNumber As Long) Dim xlsApp As Excel.Application, xlsWorkBook As Excel.Workbook...

So an example of a file name would be "Log Parser6-26.zip" Is that correct?

While entirely possible this is going to take a bit more coding as the main name of the zip file has to follow some sort of standard naming scheme other wise you would need to export them yourself anytime you wanted the database to be updated.

No worries the best of luck to you.

Here is an updated version that grabs some of the fields from the CSV example file you provided and puts the data in the table. If this is what you want just follow the sequence of code that I have in there to finish it out. There was just way to many fields for me to set down and type them...

it should allow me to select a .csv file. However, when I tried to see if it would work with the sample file I attached earlier, it would not display that file, for me to select. All you need to do is in the function: Function GetDataFromExcelSheets(lSheetNumber As Long) Replace the following...

I attached a sample database that all it does is open the excel files one by one and printing out some data in the immediate vba window. Try it out and make sure to open the modules so you can change the numbers and letters as you need to for your files. If you need help let me know.

I apologies for dropping the ball. I'll get it to you today.

No worries that's fine. It's not hard to change things around and you should be able to do that yourself with the code I'll be posting. Anyway I'll be posting the module in about 2-3 hours. Talk to you then.

That link is to the website housing the list of files as it is an aspx file which is appart of the .net files. We need the direct link to the file itself initially to do the testing. Then after that we can devise a way to read the contents of the aspx from sharepoint to get a list to run...

Do not worry about that. If you open the file with excel it lays it out in a standard format. I'll be posting the code today in a module so you can just download it and insert it into your project. I need an example path to your sharepoint file though. Please provide that information and I'll...