Search results

assumming this is my flat file. ( 4 rows) "A FIELD","B FIELD","C FIELD","D FIELD" INTEGER,INTEGER,INTEGER,VARCHAR(50) 1,2222,20130204,XYZ450 1,2223,20130204,XYZ460 I want to append the value of 3rd and 4th row to my table. in my table the fields is already exactly the same with the columns...

Thanks Dave i already have a file browser in the form, i only need how to insert the flat flat programmatically.

Hi, I have one Access Database and i want to import the flat file coming from Cisco Phone Logs, its a comma delimited that contains the column names in the first row, and in the second row, its the data type, then the succeeding rows contains the data of the logs which are in Comma separated...

Thanks for the reply and added points, I appreciate your help but anyway I tried what you recommended to me but its giving an empty result in my QBE (Format([whatever], "\#mm\/dd\/yyyy\#"), Here is my Column Expr1: Format([Closing Date],"\#dd\/mm\/yyyy\#") Here is the criteria Between...

I really appreciate if someone could give me a correct sql. Here in my scenario. I have two tables 1. Harvest Details Harvest Details contains our detailed harvest in our farm for our cultured shimps and it contains the Pond No, Crop No, Harvest Date and Harvest Type, there are only two two...

Hello: Thanks for your reply but i think i found a better solution that accurately filtering based on my requirement, let me share it to others. In my database SQL, i made an extra field say MyDateInTxt, then used the function CONVERT(varchar(10),(mydatefile),103) to convert datetime to only...

Dear All: I had a problem with my datetime filtering in one of my query. My table is link from our SQL Database Server 2005 and im reading it in Microsoft Access using one Form and Query, my Date From and To from my form is not properly filtering the data from my query. I used the...