importing/exporting [Archive] - ForumsHQ

[syntax53]

Originally posted by Speed

I have to import text files to access at work. It's not hard. Actually, what you do is import it to excel first, which tabulates everything into columns, then from excel to access.



that i could see, i do that sometimes with stuff too. i think i use excel most as a medium between file exchanges than for doing spreadsheet data :) .. still gotta watch for commas separating fields that shouldn't be though.



-syn

[Speed]

I always use the tab wizard and set my own tabs, I don't separate by commas. Unless of course the fields are different sizes, which your data is, so I can see where the problem would be.

[WiKKiD]

so really, that hasn't solved anything..i'll try the excel first thing 2morrow, i'm bugga'd i'm goin 2 bed nite ya'll

[syntax53]

Originally posted by WiKKiD

so really, that hasn't solved anything..i'll try the excel first thing 2morrow, i'm bugga'd i'm goin 2 bed nite ya'll



why are you dealing with textfiles?!?!?!??!?!!?

[Speed]

Excellent query Syntax.