Recent content by taShi

I am trying to import a fixed format text file. I get an error saying that "One or more rows of data contain too many characters to import. The maximum characters per row is 65,000." Is this a legitimate message. I have been getting goofy errrors from Access. Does anyone know of a workaround...

I ll try that thx!

thx!! my question really is how do you use the instr() function to read a string from the right versus the left?

Does anyone have any code that reads a name field that contains the name in the following format (John T Smith), picks up the Firstname, last name, and dumps them into different fields. thx!

thanx!!!!

Can someone please define what a DBMS is?

Thanks *moron, that worked for me!!!

Raskew, Thanks for your response but I still get the same error. I get error '3061' "too few parameters.expected 1" it still errors out at the same line. Set rsResult = dbs.OpenRecordset(strSql) Any other ideas?????