[AccessD] Recordset into Text File

---- London Borough of Bromley E-Mail Disclaimer ---- 
"For information about Bromley Council visit our web site
www.bromley.gov.uk" 

"The information contained in this message (including any attachments) is
confidential in that it is intended solely for the use of the recipient to
which it is addressed. If you are not the intended recipient, the use of the
information by disclosure, copying or distribution is prohibited and may be
unlawful." 
---- End of Disclaimer ---- 

Yes, thanks Roz
 
-----Original Message-----
From: Roz Clarke [mailto:roz.clarke at donnslaw.co.uk]
Sent: 28 April 2003 15:27
To: 'accessd at databaseadvisors.com'
Subject: RE: [AccessD] Recordset into Text File
 
Ryan
 
If the text file is fixed-width then a specification is required to tell
Access where to look for each column. If the file is delimited (comma is the
most common) then the import wizard should just prompt you for the
delimiter.
 
Does that help at all?!
 
Roz
-----Original Message-----
From: Smethurst, Ryan [mailto:ryan.smethurst at bromley.gov.uk] 
Sent: 28 April 2003 15:17
To: 'accessd at databaseadvisors.com'
Subject: RE: [AccessD] Recordset into Text File
---- London Borough of Bromley E-Mail Disclaimer ---- 
"For information about Bromley Council visit our web site
www.bromley.gov.uk" 
 
"The information contained in this message (including any attachments) is
confidential in that it is intended solely for the use of the recipient to
which it is addressed. If you are not the intended recipient, the use of the
information by disclosure, copying or distribution is prohibited and may be
unlawful." 
---- End of Disclaimer ---- 
 
Hi All,
 
I'm trying to import a text file into Access and am a bit stumped by what is
required for a 'Specification Name'.  
 
I've looked at the macro dropdown list for this and it was empty.  (?)
 
Can anyone tell me what is required?
 
TIA
RyanS 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030428/220a1e09/attachment-0001.html>