hi all, i got a problem that i need a solution to before the end of the week so any help is much appreciated. i'm working on a system that allows users to import csv files and then allow them to create dynamic mailmerge and excel files. originally i was using the docmd.transfertext method to import the files, but i ran into problems with Access converting my account numbers and phone numbers into exponent notation. so to avoid this problem i wrote a function to read the first line of the text files to build the skeleton of the table and then to create the fields as dbText with 255 field length. From there i imported the file into the table. but this method created another problem, some phone numbers were unsucessfully imported. the weird thing is that some phone numbers of the same length are imported successfully. is this a known bug and is there a work around? thanks in advance.
jeff
jeff