Search results

Hi, I need to create a form with a text box and a command button; in the text box i will enter a value and when i click the button, i need it to lookup the value i write in a query and write it to a specified table's 1st column (has a column name) while also writing the other values in...

Yes HgMonaro good point! the files have .dbf extension and my knowledge on importing is yet limited to texts and spreadsheets and their specs :( a method to import multiple files with this extension also would work well..

Hello all, I am importing .xls files "CVA*.xls" to seperate tables. 1 table for each file. what i need is a code that appends all these tables with names begining with CVA* to one master table. can anyone help? thanks!

To be more specific, below code is which i use to import my .txt files with the criterias given in it. Once i import these files from the given path, as the last operation, i need them to be transferred to another location. (well, this has just flashed on my mind; why delete? let's archive them...

hi all! i have a similar situation but i need to delete all the files in the folder without any criteria. they are also .txt files. could someone share a code that i can use ? thanks!

Each file begins with the record "VPLHDR*" but the following date changes for each .txt files. Considering this project i work on i s a ABC analysis and forecast analysis, i will need the date information in a second field for each records. Should be like below; VPLHDR*** 20100420...

of course.. i still need it..

well friend, nescience is worst :) i can now import also the first lines as records! thaks for the tip!

hi pkstormy, Your db file seems quite useful, thank you for sharing on the issue. i will study it and try to edit the codes to be able to import .txt files instead.

Yes, exactly..

i attached an image file shows what i exactly need to do within the code above :)

hi, records are about 100k for each file.

Hello everyone, I have a problem with importing text files with an existing specification. My specification works well if i import a file manually, but i also use a code to import multiple files (.txt) with a criteria which is to be found in below code. The code i acquired is importing the...

I managed to import all the files with using the spec created for these files, by using "SpecName" here below, DoCmd.TransferText acImport, "VPL", "VPL", ImportFile, True all the files with given criteria are imported to a single table now. but the first lines of the text files which were...

hello Lightwave! The files i import are completely identical. they begin like below; VPLHDREAAFB 20100423 VPLISTAN0AT0363700D 786 AB 001.00000 VPLISTAN0AT0364966G9N 3K185 BJ 001.00000 VPLISTAN0AT0365369T1H 19E647 BJ 001.00000 ..... ...

ok here's the real challange for me; these files -since they are text files- do have different field names once they a re imported to the table, since their first lines are different. and i receive an error message and whole opration stops; 2391 field name does not exist in the destination table...

good news! i can now import .xls files all of them to the same table, and they are being appended each time i run the code. i left the Folder here as blank; ' get the DB path DB_Path = "C:\Users\Q\Desktop\FTP\" Folder = "" FileCriteria = "C:\Users\Q\Desktop\FTP\" & "VPL*.xls" Can i also use...

With this layout i receive error 3011, which is saying "the microsoft jet engine could not find the object c:\users\q\desktop\FTP\VPL111.xls . to make sure if the file exists the name is spelled correctly ... Function Load_Attendance_Data() Dim NextFile, ImportFile, FileCriteria, ctr As...

I did just like you said, and both with and without the second code, when i run the mod, i have the error "File not Found" now. i just uploaded the db1 file as i created. how could i handle it?

well thanks for the codes! though i didn't really understand how to use it and how to specify my data into the code. it gives me an error; Compile error, sub or function not defined. the problem is, i don't know which parts of the code is to be adapted to retreive my files from my locations into...