Search results for query: *

OK, thanks. Now it's perceiving an error, as it's making the Out directory, but it still jumps straight from MkDir cstFilePath & "Out" to Stop (under AggregateFile_Error) I have breaks at: intout=Freefile Open cstFilePath & "Out\Temp.csv" For Output as #intTemp and various other places...

Hi CMP, I have it in Access and have been toggling through some breaks, as it starts to run, gets as far as creating the output directory but doesn't actually import the files. All I needed to change was the input directory right? I've pasted what I've been using below: Sub AggregateFile()...

Hi again, Thanks to both CMP and Golom for their help on this. I haven't managed to get the code to work yet - should I be running is as a module in Access or directly in Visual Basic (I have version 6)? Re: the positional accuracy - only the first 15 columns matter, after that it isn't...

It's a conservation planning software called ResNet (see the conservation software link at http://uts.cc.utexas.edu/~philsci/sarkar/main.html). It accepts text files only.

Thanks for the soln - it imports the first file but none after that - I guess I need to change the name of the file that was just imported so it is no longer recognised by the module. How would i do that? Re: 1300 columns, each csv file is a presence/absence species distribution. I have 1300...

First off, that sucks! So I'm going to have to figure out how to amalgamate them too. Eeek. Re: code, I have the following so far to try to import the files as separate tables, but I get an error message (Runtime error 3011 The Microsoft Jet database engine could not find 'S100025.csv'. Make...

I have 1300 .csv files, with a single column & 260,000 rows each. The file name is the name I would like to assign to the field. Is there any way to automate importing the files into Access one at a time, each time adding a new field & assigning the file name to the field name? End product would...

Hi, I have been using Access 2002 for a while now, and more recently in conjunction with GIS. I have been importing the .dbf file from the GIS info into Access to edit the attribute data more efficiently, re-exporting it as a .dbf and that .dbf has been the new attribute table for the geographic...