Recent content by amal2004

I did little modification on the code, but now I get a different error “External table is not in the expected format” This is what I have <CODE> Option Compare Database Sub Test1() Dim objFSO As Object Dim objFile As Object Dim strPath As String Dim strFilePath As String Dim objFolder As...

I think the process is good if we find a way to make it loop without giving an error Cant find file name . What shell I do ???

Same problem . the code goes throught all lines and when it does the import for the first file and loops ( Next objFile) it get stuck saying cant find file name !!!??? Please help

i did my first import . Thanks , but i have an error after it loops the first time saying cant find object !!! Thats what i have Sub Test() Dim objFSO As Object Dim objFile As Object Dim strPath As String Dim strFilePath As String strPath = "C:\Workbooks" Set objFSO =...

TomHW, Thanks for your help. i started working with it in access . It stops on this line ""For Each objFile in objFSO.GetFolder(strPath)"" And an error says Object does not support this property or method. Please help me find a way to loop through the files and start appending the data on the...

Thanks for this nice start. but how will i include MS access in the code . Shell i use ADO or DAO ?

Hello , I have 200 workbooks in a folder , every workbook has a sheet with couple of lines of data , all workbooks are the same , I need to write code that will loop inside this folder , open every workbook , take the lines of data and have them all in one Table or excel sheet . Can we do...

Option Compare Database Option Explicit Public Sub GetJolts() Dim txtparse As String Dim rst As Recordset Dim File As String Dim path As String Dim Db As Database File = InputBox("Enter File Name", "Eneter Name") If File = "" Then Exit Sub End If DoCmd.Hourglass -1...

Hello , I have a problem i need help . The goal is to import a text file into an a Access Database using VBA. I am having problems write code to 1- [Open a Text File from an Access 2000 DB] 2-Use the find and replace method to find any (,) and replace it empty. Meaning to take the (,) out...

Hello .. This process starts by downloading data for couple of accounts from an oracle web database. This Download should occur at the end of the month so as to have all month’s data. One of the fields needs to be researched and updated with the missing info. This research takes a good amount...

I have a table that has an [order id] column and a [rep id] column. An order could have two reps or more associated with. I would like a have a query that will bring me all the orders that have more than one rep associated with. Thanks

I really do appreciate any help. Hello I am trying to create a form in access 2000 with a text box and a button. When you enter a value in the text box like ID Number and click the “Get” button, I need another form to pop up with the info related to that ID.. The Table that i have this info...

VBAjedi .. Thanks for your reply... I am sorry if I did not mention that i am using access form the start.. Please can you guide me through making the forms and entering the code, i am a fast Lerner .. Thanks

PHV :-) I am working with access 2000. I need to know what criteria shell i put in the first form and what should be in the open event of the secound form (The pop Up form).... Thanks

Hello I am trying to create a form with a text box and a button. When you enter a value in the text box like ID Number and click the “Get” button, I need another form to pop up with the info related to that ID.. I really do appreciate any help.