Recent content by nikotromus

The file has some phone numbers of customers that I can't post. It is a fixed width, tab delimited file. Thanks for the interest. Ryan

Again, this is data in a text file. It was produced by a reporting system. I don't work with tables that are 255 columns long. I just need a way to read in this flat file, and then I can break it up from there.

When I am importing a file and I am on the screen where it give me the option to skip a field from importation, it will not allow me to select any field except the first field. The screen gives you field options at the top, and it lists the fields at the bottom. This would work if it would...

If I could transfer half of the columns in the text file to another text file, that would solve all of my problems. Then I could import both of the flat files seperately. I don't know of a tool that will allow me to do that.

I will be happy to break up the text file once I read it into Access. The problem is, I have to read it into Access first before I can break it up. It wont let me read in more than 255 columns

Hey Guys, I have a big problem that I have been wrestling with for quite some time. I am trying to import a text file into Access that has more than 255 fields. Do you have any suggestions on how to get around this? Any help will be greatly appreciated. Ryan