<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word"><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>RE: [AccessD] Recordset into Text File</TITLE>
<META content=Word.Document name=ProgId>
<META content="MSHTML 6.00.2722.900" name=GENERATOR>
<META content="Microsoft Word 9" name=Originator><LINK
href="cid:filelist.xml@01C30D98.94A61BD0" rel=File-List><!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:DoNotRelyOnCSS/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:Zoom>0</w:Zoom>
<w:DocumentKind>DocumentEmail</w:DocumentKind>
<w:EnvelopeVis/>
</w:WordDocument>
</xml><![endif]-->
<STYLE>@page Section1 {size: 595.3pt 841.9pt; margin: 72.0pt 90.0pt 72.0pt 90.0pt; mso-header-margin: 35.4pt; mso-footer-margin: 35.4pt; mso-paper-source: 0; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline; text-underline: single
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline; text-underline: single
}
A:visited {
COLOR: blue; TEXT-DECORATION: underline; text-underline: single
}
SPAN.MsoHyperlinkFollowed {
COLOR: blue; TEXT-DECORATION: underline; text-underline: single
}
P.MsoAutoSig {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"
}
LI.MsoAutoSig {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"
}
DIV.MsoAutoSig {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"
}
P {
FONT-SIZE: 12pt; MARGIN-LEFT: 0cm; MARGIN-RIGHT: 0cm; FONT-FAMILY: "Times New Roman"; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto
}
SPAN.EmailStyle18 {
COLOR: navy; mso-style-type: personal-reply; mso-ansi-font-size: 10.0pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EN-US style="tab-interval: 36.0pt" vLink=blue link=blue>
<DIV><SPAN class=003555923-28042003><FONT face=Arial color=#0000ff size=2>A
specification name is a name you can give to a 'pre-built' or saved
specification. When you import a file through the wizard, in the last step
or two, there is an Advanced button. That button will let you Save an
import/export spec, by name. That is what the macro is asking for.
If you leave it blank, it will use default settings. If you give it a
name, it will use that spec to import the file. The spec tells it what
columns to import, the delimiter, etc.</FONT></SPAN></DIV>
<DIV><SPAN class=003555923-28042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=003555923-28042003><FONT face=Arial color=#0000ff size=2>Just a
note, when you import objects into a database, one of the options is to import
import/export specs....keep that in mind if you have to 'rebuild' the database,
those specs need to be imported too.</FONT></SPAN></DIV>
<DIV><SPAN class=003555923-28042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=003555923-28042003><FONT face=Arial color=#0000ff
size=2>Drew</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Smethurst, Ryan
[mailto:ryan.smethurst@bromley.gov.uk]<BR><B>Sent:</B> Monday, April 28, 2003
9:17 AM<BR><B>To:</B> 'accessd@databaseadvisors.com'<BR><B>Subject:</B> RE:
[AccessD] Recordset into Text File<BR><BR></FONT></DIV>
<P><B><I><FONT face=Arial size=2>---- London Borough of Bromley E-Mail
Disclaimer ----</FONT></I></B><I></I> </P>
<P><FONT face=Arial size=2>"For information about Bromley Council visit our
web site www.bromley.gov.uk"</FONT> </P><BR>
<P><FONT face=Arial size=2>"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." </FONT></P>
<P><B><I><FONT face=Arial size=2>---- End of Disclaimer ----
</FONT></I></B></P><BR>
<DIV class=Section1>
<P class=MsoNormal><FONT face="Times New Roman" color=navy size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: navy">Hi All,</SPAN></FONT><FONT
color=navy><SPAN
style="COLOR: navy; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" color=navy size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: navy"><![if !supportEmptyParas]><![endif]> </SPAN></FONT><FONT
color=navy><SPAN
style="COLOR: navy; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" color=navy size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: navy">I'm trying to import a text file into
Access and am a bit stumped by what is required for a 'Specification
Name'.<SPAN style="mso-spacerun: yes"> </SPAN></SPAN></FONT><FONT
color=navy><SPAN
style="COLOR: navy; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" color=navy size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: navy"><![if !supportEmptyParas]><![endif]> </SPAN></FONT><FONT
color=navy><SPAN
style="COLOR: navy; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" color=navy size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: navy">I've looked at the macro dropdown list
for this and it was empty.<SPAN style="mso-spacerun: yes">
</SPAN>(?)</SPAN></FONT><FONT color=navy><SPAN
style="COLOR: navy; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" color=navy size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: navy"><![if !supportEmptyParas]><![endif]> </SPAN></FONT><FONT
color=navy><SPAN
style="COLOR: navy; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" color=navy size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: navy">Can anyone tell me what is
required?</SPAN></FONT><FONT color=navy><SPAN
style="COLOR: navy; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" color=navy size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: navy"><![if !supportEmptyParas]><![endif]> </SPAN></FONT><FONT
color=navy><SPAN
style="COLOR: navy; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" color=navy size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: navy">TIA</SPAN></FONT><FONT color=navy><SPAN
style="COLOR: navy; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" color=navy size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: navy">RyanS</SPAN></FONT><FONT
color=black><SPAN style="COLOR: black"> </SPAN></FONT></P></DIV>
<P></P></BLOCKQUOTE></BODY></HTML>