Hi Jeff- thanks again for all the feedback! Had to all this on hold till after my vacation (reason good enough!) 🙂

A gave the data upload a new try, but...

hi! thanks for the response. I actually tried both options on a larger data set and found that if a "relationship" records ins't included if it doesn't have its "Reciprocal"...

hi there! sorry I didn't get back to you, but got caught with work stuff. I briefly tried the code you sent against a txt file I created and...

Hi there!

Yes please, I would love some help!

I've put together a format file to read and upload a sample txt file, but still have trouble...

hi Jeff- so I tried BCP using a format file in xml, but I keep getting the same truncation error, which I believe it is still due to the embedded...

hi! I tried your suggestion on a small tbl, and worked well. However, I got some issues on bigger tlbs (50+ million records). I'm trying other options for those biggie...

That'd be extremely helpful! Thank you!

I'm just reading more and getting acquainted with the BCP utility, as I believe I'll need to use it often.

m@rcelo

thank you for the tip. the solution seems logical and doable. I'll give it a shot and see how it goes. my concern is that I might still run into...

Hi Jeff- I realize this is an old post, but the problem's current. :hehe:

The issue I have is similar to others. I received .txt files with the pipe or vertical...

Hi- thank you for sending the accdb. sorry for the late response though. It actually worked well too, just like the sql script I also got.

thanks again for your...

Hi Jeff-

thank you so much for the answer. That is exactly what I was looking for! I tested and worked like a charmed. Now, I've got to implement it...

Yes. However, the table can be loaded in SQL server as well, so anything I could do in SQL would be great too. And if so, I can just dump...