Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Importing / Linking / May 2005

Tip: Looking for answers? Try searching our database.

Creating an import spec file from a file layout document

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
dball - 26 May 2005 22:20 GMT
I typically get an ASCII fixed width layout text.  With each, I also get a
.txt layout document.  How can a turn the layout document into an import spec
file?  (Each file's layout is different and Here is a sample of a layout file
I get.

Thanks
Dave

RECORD LAYOUT FOR: XXXXX.TXT
POSITION    LENGTH    CONTENTS
__________  ______    ________
 
   1-    9     9       Key 1
  10-   18     9       key 2
  19-   26     8       DOB
  27-   27     1       Gender Prime_INDV_Age
 28 -  31      4       Name
  32-   66    35       address
  67-  101    35       city
 102-  136    35       state
 
etc....
Douglas J. Steele - 26 May 2005 23:17 GMT
Take a look at http://support.microsoft.com/?id=155512

While it only lists Access 95 and Access 97, I believe it applies equally to
all versions.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>I typically get an ASCII fixed width layout text.  With each, I also get a
> .txt layout document.  How can a turn the layout document into an import
[quoted text clipped - 20 lines]
>
> etc....
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.