Search results

it doesnt register anything and only shows one blank line. so where is all the data that the delete query wants to delete??? This is so bizarre and frustrating. I am going to run the data via excel for each day and see if I can at least paste it over, until I can get my append query to work.

Thanks, this is attempt number three. Have deleted the module and renamed the type field to action maybe this will work. I dont get how the dat is not going into the table but when you run the delete query it says I am about to delete 191934 rows from the specified table. This being the import...

Sorry I deleted the original db that I built before the IT guys saw the size. so the one i sent was the one I was rebuilding. Have rebuilt my append and delete queries for you. Very strage though that the maketable query doesnt make a table!! bizarre. Thanks muchly for your help with this.:)

hope this through ok:)

Tried it already. Im in the process of building another database to see if this ones has gremlins. I think it must be putting the dat somewhere as it is 590,976kb and growing, but I just cant see it. Will try this in a new db and see if it works. thanks again Built a new db, wich is now only...

thanks for that will try, however, qry_email1 has a format in it to change the date around. The original format is date and time. will this still work, do you think????. Many thanks again Tried it, and it pulls the data but still does not insert it into the import table or not that I can...

Well I can safely say after about 10 attempts to connect the ODBC changing the field name didnt work. AAAAArggh, V. frustrating. Any other ideas. Please. Can I also say, and this is the weird bit. If I have run the append query and the info has come up in the datasheet view, I dont see it in...

All the message that comes up is that 'You are about to append a query' which I ok. I will try changing the feild name. Fingers XXXX

The actual append query allows a datasheet view. The coding is copied from a successful database??? Can you suggest another type of sql which will do what I want??? Believe me any bit of advise is gratefully received, as I have spent ages comparing with other append queries to find out why this...

The append query pulls the data from the main query. I have them set up on a macro but because it is such an unreliable ODBC connection its nightmare to run the macro. so I run each query individually, the data comes up but when I check the import table there is nothing there? Thanks

HI there, sorry a bit of a newbie to access. I am trying to do an append query, or should I say I have done an append query. I am trying to build a database. The first query pulls data from a server with four tables linked into this, when you fnally get the ODBC to connect the data comes...