Search results

Hello all: I need your help with the following. I have a table in access, the fields I would like to filter on are: Sales org Profit center Account Customer I would like to do the following in this sequence: 1) Filter for Sales org= 6101 then 2) provide all profit center after filter (1)...

Hi: When I closed the db and opened it again, the tables and queries where back!!! Don't know what is happening. I tried rerunning the code and voila, it worked!!! It created another table called tbl(with the table name I included in the code), I thought it would just import the information...

Hi: I have included the "\" and the code started running. But all of a sudden, I got an error 3000 - "there is no message for this error". When I looked at my database, my tables and queries have vanished!!! but the reports are still there. Do you know why it would do that. How can I make...

Thanks for the code. I did try it, but I am gettin this error: "3011 The microsoft Jet database engine could not find the object ..." it lists the first txt file in the folder I am trying to export. Here is the code you suggested, I just changed the file path and the spec: [code] Private...

I searched the forum before posting my question, but did not find any post that could help with my problem. If you can direct me to a specific post that could import delimited text files into 1 access table with a saved spec, please let me know. All you kind people out there, if you have any...

Thanks much Pat, that helped.

Hello all: I have several (over 300) txt files (with very different file names) that I would like to import into Access simultaneously, they all have the same fields and are in one folder. Since they are text, the files are delimited with " and I also have a saved spec that I use before...

Hello all: I have multiple tables in my access db, the structure of the tables (4 in all) are exactly the same except that the billing dates are for year 2001 to 2004 i.e. separate table for each of the years. I don't want to copy the information in these 4 tables into 1 table because I have...