Cannot append text file to Table - "Subscript out of range" error

[Goat.Cheese]

EDIT: since i dont have the post count to post links, you would have to replace /com with (dot)com manually if you wish to see the snaps. Sorry

Hi,

I need to create an access table which to hold a rather sizeable amount of data.
I created this table,

i45.tinypic/com/30rtg01.jpg

named the fields to be used, set data type - the fields are around 30 in number.

But when i try to append this .txt file

i48.tinypic/com/ws22pd.jpg

and set the delimiter to | , I get "subscript out of range" error.
Still new to access, and cant figure what im doing wrong. If i just import the entire .txt file witthout appending it to a table, i get my chart, but its littered with the | signs all over.

Basically i need the text to import to the pre-set table, without any extra baggage, but so far ive gotten 3 different error if i try to imrovise wit the settings.

Here is the screen, after which I get the subscript out of range error.
Also, could anyone tell my why do i get that weird symbol in the top-left corner?

i49.tinypic/com/97206o.jpg

Cheers

 

[John Big Booty]

Re your inability to post images check this link.

 

[Goat.Cheese]

Re your inability to post images check this

I am fairly certain that its far easier for both parties to replace one symbol in a copied text, rather than archiving it, uploading it, and having people download it.

And i wouldnt call my post "irrelevant" , If thats what you were implying.

 

[John Big Booty]

...

And i wouldnt call my post "irrelevant" , If thats what you were implying.

That was certainly not my implication. I was merely pointing a how you could post your image.

 

[Bryan]

I'm not sure why you're getting that garbage at the top, but my first thought is that you're not starting with a pure text file. I'd look at the file with a hex editor to see if there is more there up front than notepad is displaying.

As an alternative, you can try importing that file into excel first and then into Access.

 

[Goat.Cheese]

Well, i decided instead of appending the data to a table, I'd just import it as an entirely new one, and just manually name the 30 fields. Worked with much less hassle and no errors.

The weird text that was displacing the first row, seems to be the result of the wrong code type. Shoulda been Unicode-8