Recent content by dSurvivalist

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 ..... ...