briananderson
Registered User.
- Local time
- Today, 12:10
- Joined
- May 8, 2008
- Messages
- 17
I'm trying to figure out if its possible to import a text file thats space delimited in to access. See the example text file below. I can import it via space delimited, but the titles of the movies that have spaces gets parsed up too. Is there a way to just parse the first few spaces and then group everything else into one field?
I have 3 fields: BoxType, BoxNumber, and MovieTitle
BOXTYPE-A 1 TITLE OF MOVIE1
BOXTYPE-A 1 TITLE OF MOVIE2
BOXTYPE-A 2 TITLE OF MOVIE3
BOXTYPE-A 2 TITLE OF MOVIE4
BOXTYPE-A 3 TITLE OF MOVIE5
BOXTYPE-A 4 TITLE OF MOVIE6
So I'd like it to look like this:
BoxType: BOXTYPE-A
BoxNumber: 1
MovieTitle: TITLE OF MOVIE1
Is this possible? Thanks!
I have 3 fields: BoxType, BoxNumber, and MovieTitle
BOXTYPE-A 1 TITLE OF MOVIE1
BOXTYPE-A 1 TITLE OF MOVIE2
BOXTYPE-A 2 TITLE OF MOVIE3
BOXTYPE-A 2 TITLE OF MOVIE4
BOXTYPE-A 3 TITLE OF MOVIE5
BOXTYPE-A 4 TITLE OF MOVIE6
So I'd like it to look like this:
BoxType: BOXTYPE-A
BoxNumber: 1
MovieTitle: TITLE OF MOVIE1
Is this possible? Thanks!