Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Import Manager Fixed Width TxT - How??

Status
Not open for further replies.

karcheee

Programmer
Jun 8, 2006
1
CA
Hey all:

I'm having trouble with a fixed width text file. I need to get this file working as an integration source. However, I dont know how to set the fixed width delimiter - when I select 'space' delimiter then I get an error when I click on 'columns' saying that the Jet Select statement failed to detect the columns and that the delimiter settings are probably wrong. I get the same error when I select 'other' and put spaces in the text field next to 'other'. I dont see anywhere to set 'fixed witdth' in the integration source setup.
How do I setup a fixed width text file integration manager source??

Thanks,
Karl
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top