trying to import .txt file

R

RHD3

Hello,
I'm tring to import a large text file into access. Actually I would rather
"link" to this file. I've created a blank table with column widths
corresponding to the coumn widths in the text file. The txt file is space
delimited and "character (+)" delimted. The coumn widths are not all the
same. The first column is 10 characters, 2nd column is 4 characters, 3rd
coulumn is 1 character, 4th coulmn is 30 characters, etc. This file is
updated on a daily basis which is why I would rather link to it than import
it. I could post layout if that would be helpful.
Thank you.
 
J

John Nurick

Hi,

Access's built-in routine for importing and linking delimited text files
require that the the same delimiter character is used throughout the file.

Can you change the software that produces your file?

John Nurick
Microsoft Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove Identical words 0
Unknown characters in .txt import 0
Import | and ¦ Delimted Text Files 1
Import .dat to access 2007 0
import txt file 4
Import txt file - records on multiple lines 1
Importing Excel Data Into MS Access Memo Field 1
How do I import a signed field into access data base? 1

Top