Search results

okay, thanks once again! :)

Let me bug you one last time, i was testing the imports and i noticed that when it imports its missing the 1st record from every txt file? It looks like it was doing this before you help, any idea what could be causing this?

Thank you for your help, it works like a charm, it actually even imports faster too... :D

thanks for the help, i'll try it out when i get to work, and let you know the results.

i know that the date would copy over to each record found in the file, but it's something i need. I would expect there to be some changes to my import code, i'm just asking for some help in actually being able to copy the date portion.

that seem like it could work, i'll try it out on access when i get a chance and let you know how it turns out. thanks :)

it doesn't work on 2007, but i found a pc that wasn't updated and figured i use it till i fix the code to work on 2007, but i realized that regardless i need a way to extract the date from the file name..

Hi, I have a table with login info, and i'm trying to find the latest login per account. table Ex. AccNum UserID Login_Time 123 m 7/19/2010 123 v 7/20/2010 111 a 1/2/2010 222 q 7/20/2010 333 b...

Thanks, question tho, how do i incorporate that into my current code i'm using for the importing of multiple files. Below i copied the code i'm using for the importing which works fine just need help on extracting the date from the file name. Public Sub subImport() On Error GoTo Err_subImport...

Hi, I use a madule to import multiple txt files... Is there a way to import a file and at the same time extract part of the file name to populate a column? All the files i'm working with have the following format: FileNameMM-DD-YY.txt ex. XYZ07-19-10.txt XYZ07-20-10.txt XYZ07-21-10.txt...

Hello, I'm using a module i had for an access 2003 DB using ".FileSearch" property, but my computers at work have upgraded to access 2007. Could some body please help me convert this section of code to work on 2007? This is the error msg i get when i use my current code. "You entered an...

Would it be much asking for an example, or where to find more info on using a record set and variable?

I have to import a txt file into a DB to track trends. Below is an example 1 (attached) of the layout of the file. When I import the file the data transfers without a problem. The only thing is that there is a “Batch” column which as the data which is different as the txt file loads. I have been...