Recent content by curtinch

So, the actual issue I was having was not with my code but it was with a data type in my table design. Below is now my working code that successfully brings in 274 tab delimited fields into two tables. Public Sub ImportTextFile() ' to use the ADODB.Recordset, be sure you have a reference...

I was wonder if anyone could give some insight. I'm trying to import a text file with 273 fields into two tables. I've been able to do this with the help of code I found on an old thread and I'm now trying to accomplish everything with one step. The file I'm importing is tab delimited text file...

Hi Bob, your post above has been very helpful. I was wonder if you could give some insight. I'm trying to import a text file with 273 fields into two tables. I've been able to do this with the help of your code in two steps and I'm now trying to accomplish everything with one step. Could you...