CranstonSnord's latest activity
-
CCranstonSnord replied to the thread Solved Key Violation Error Trapping During TransferText Operation.After much dinking around, I was able to get Access to link to the text file using my IMEX spec in one statement, and then use the...
-
CCranstonSnord replied to the thread Solved Key Violation Error Trapping During TransferText Operation.Thank you once again for all your time and help. Unfortunately I'm enough of a newbie that I have no clue how to upload an empty...
-
CCranstonSnord replied to the thread Solved Key Violation Error Trapping During TransferText Operation.The spec absolutely exists, because I have already imported/exported with it many times successfully. However, Access only returns the...
-
-
CCranstonSnord replied to the thread Solved Key Violation Error Trapping During TransferText Operation.Got it. I have already created the IMEX spec, so that's not the issue. Here's what sSQL looks like using my data: INSERT INTO...
-
-
CCranstonSnord replied to the thread Solved Key Violation Error Trapping During TransferText Operation.Thanks Pat. The only portion of the solution that @ebs17 posted that I'm still unsure of is how to create the DSN NameSpec. Would I have...
-
CCranstonSnord replied to the thread Solved Key Violation Error Trapping During TransferText Operation.Wow, thanks for your quick response! All the above looks really cool, but there are some moving parts that I don't know how to fit into...
-
CCranstonSnord posted the thread Solved Key Violation Error Trapping During TransferText Operation in Modules & VBA.- All - I have reviewed many threads across this site and elsewhere, but didn't see an answer that fit my exact situation. I have a...
-
CHello to one and all. I have joined this forum in the hopes that some of my obscure, pesky Access problems might be answered by those...
