Search results

OK. that is why you are saying no transferspreadsheet - just query the csv. Thanks. One last question? So if I am executing append queries in sequence, I will need to preserve the auto number from the prior record to use as a foreign key in the next recordset I create. Correct? How do I save...

OK. Thank you. I will need to study this! .

CJ I have worked a bit with your code for doing a table append. Thank you very much. So I "trim" up the csv I get from the form (basically elevate row 2 to be column names) then from MS Access do DoCmd.TransferSpreadsheet to create a table in Access from the csv. Then I can take that table...

Wow, OK thank you so much for that information. That's a lot; I appreciate it.

I again apologize for the "cross posting". If someone could suggest the appropriate penance I would do it so we could get this over with. I have a little dachsund I am growing tired of, would that work? (Kidding I love that frustrating little hound). I am not exactly expecting "shiny...

Thanks very much for your comments and attention. I think I am at a crossroad here: stay with Access or either buy or create a more specific case management system. The most obvious concern - which as kept me tethered to Access - is the difficulty of migrating my data. There seem to signs...

OK

No original post issue not solved in an acceptable way. It is possible to download the CSV file, edit it by hand, import to MS Access by hand, then ask another question set via online form and repeat this process. Zapier does not seem to like MS Access so that is a hinderance. I am currently...

I showed no disrespect to anyone here -including you Doc Man but you have shown me great disrespect - lecturing me about how I "have a problem" that the Access Tribe all "recognizes": how condescending! You did not return me respect sir. The example is coming from the top.

I see. Thank you Pat.

Could you explain a little more how you link to an excel worksheet in Access rather than import to temp table?

OK.

You have presented a solution which seems to address my desired result: updating an MS Access table with data from a csv file. I have thoroughly read your post and I do not understand it So if you can put aside your views on my "attitude" I will try to check same at the door as you have...

OK

So cute and clever. You must be murder on Facebook.

I agree this is not Facebook, but IMO your members brought that attitude here as do you. I don't find anyone wanting here - I resent the insinuation that I am opinion shopping: I have something that needs to be done. I resent insinuations such as "why don't you just ask JotForm - they have been...

OK....

Amazing. I have marked the post as solved yet the pot shots keep coming.

I see on the homepage there are many glowing reviews. My experience as less than spectacular: snarky and condescending attitude. Bet you won't give the chance to post a review on your homepage!