>Alright, I totally overlooked something in an application I'm writing.
>What I need to know is how to write all the data in a table out to a
>file so that it can be loaded back into the table in the future.
>However, I'm a somewhat pseudo-newfy with VB/VBA (I'm mostly a
>Java/PHP/C based languages kinda guy)...  anybody got any ideas on what
>I should look into (btw:  I currently have no books and no money... so
>online references would be great, or if you just wanna tell me the
>answer. =)

>-ryan

> You can use the TransferText method (see the online help) to export
> to/import from a text file.  The only hitch I know about is that
> TransferText tends to round floating-point fields to two decimals, possibly
> losing significant data.  If this is a problem, you can first create a query
> that formats the problem fields into text expressions with the desired
> degree of precision, and then export that query.  On import, you should be
> able to import directly to your table.

> You can also transfer data to/from other formats, such as another Access
> .mdb file, an Excel spreadsheet, and so on.  It's in the online help.
> --

> Dirk Goldgar
> (to reply via email, remove NOSPAM from address)

> >Alright, I totally overlooked something in an application I'm writing.
> >What I need to know is how to write all the data in a table out to a
> >file so that it can be loaded back into the table in the future.
> >However, I'm a somewhat pseudo-newfy with VB/VBA (I'm mostly a
> >Java/PHP/C based languages kinda guy)...  anybody got any ideas on what
> >I should look into (btw:  I currently have no books and no money... so
> >online references would be great, or if you just wanna tell me the
> >answer. =)

> >-ryan

>So far so good man.  Thanks for the advice.  Quick question though:  Is
there a
>way to NOT supply the file name so that the user can specify the file name
and
>where on the network he wishes to save it?

>-ryan

>> You can use the TransferText method (see the online help) to export
>> to/import from a text file.  The only hitch I know about is that
>> TransferText tends to round floating-point fields to two decimals,
possibly
>> losing significant data.  If this is a problem, you can first create a
query
>> that formats the problem fields into text expressions with the desired
>> degree of precision, and then export that query.  On import, you should
be
>> able to import directly to your table.

>> You can also transfer data to/from other formats, such as another Access
>> .mdb file, an Excel spreadsheet, and so on.  It's in the online help.
>> --

>> Dirk Goldgar
>> (to reply via email, remove NOSPAM from address)

>> >Alright, I totally overlooked something in an application I'm writing.
>> >What I need to know is how to write all the data in a table out to a
>> >file so that it can be loaded back into the table in the future.
>> >However, I'm a somewhat pseudo-newfy with VB/VBA (I'm mostly a
>> >Java/PHP/C based languages kinda guy)...  anybody got any ideas on what
>> >I should look into (btw:  I currently have no books and no money... so
>> >online references would be great, or if you just wanna tell me the
>> >answer. =)

>> >-ryan

> Your best bet is to get the file name from the user first, store it in a
> variable, and pass that to the TransferText method.  If you want to use the
> common Windows File Save dialog to get the name and path from the user, see
> this link:

>     www.mvps.org/access/api0001.htm

> Note:  it's possible I have got the wrong filename in the above link, as I
> keyed it from memory, but if you start with www.mvps.org/access, you should
> be able to find it.

> --

> Dirk Goldgar
> (to reply via email, remove NOSPAM from address)

> >So far so good man.  Thanks for the advice.  Quick question though:  Is
> there a
> >way to NOT supply the file name so that the user can specify the file name
> and
> >where on the network he wishes to save it?

> >-ryan

> >> You can use the TransferText method (see the online help) to export
> >> to/import from a text file.  The only hitch I know about is that
> >> TransferText tends to round floating-point fields to two decimals,
> possibly
> >> losing significant data.  If this is a problem, you can first create a
> query
> >> that formats the problem fields into text expressions with the desired
> >> degree of precision, and then export that query.  On import, you should
> be
> >> able to import directly to your table.

> >> You can also transfer data to/from other formats, such as another Access
> >> .mdb file, an Excel spreadsheet, and so on.  It's in the online help.
> >> --

> >> Dirk Goldgar
> >> (to reply via email, remove NOSPAM from address)

> >> >Alright, I totally overlooked something in an application I'm writing.
> >> >What I need to know is how to write all the data in a table out to a
> >> >file so that it can be loaded back into the table in the future.
> >> >However, I'm a somewhat pseudo-newfy with VB/VBA (I'm mostly a
> >> >Java/PHP/C based languages kinda guy)...  anybody got any ideas on what
> >> >I should look into (btw:  I currently have no books and no money... so
> >> >online references would be great, or if you just wanna tell me the
> >> >answer. =)

> >> >-ryan