Re: Import Text with Spec File
Tech-Archive recommends: Fix windows errors by optimizing your registry
Import the text file to a temporary table, then use an append query to copy
the data to the permanent table -- and add a calculated field to the append
query that writes the desired date into the date field.
--
Ken Snell
<MS ACCESS MVP>
"John" <John@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1E4D63D1-8802-48B5-B00D-D704DDF70EE3@xxxxxxxxxxxxxxxx
I am trying to import a text file and have a Spec file that defines the
field
properties. When I import the text, I want to also populate a date field
in
the import table. The date field is not defined in the text file. I want
to
populate the field when I execute the TransferText method. The value of
the
date field would be the same for every record.
If this can't be done, is there anyway to do this without creating a
schema
file?
.
Relevant Pages
- Re: Default Value question
... Run an append query to copy the data from the first table to the ... permanent table. ... Include a calculated field in this query that provides the ... and it is importing beautifully. ...
(microsoft.public.access.externaldata) - Re: how do I add leading zeros to columns
... your permanent table. ... In this append query, use a calculated field instead ... "Dave" wrote in message ...
(microsoft.public.access.gettingstarted) - Re: Is it possible to Change String Delimiter without using an interface Spec?
... VBA doesn't come into it unless you want to automate the whole process ... appends it to the new table, using calculated field with an expression ... append query" and "Create an update query". ... >> Please respond in the newgroup and not by email. ...
(microsoft.public.access.externaldata) - Re: have one form open many tables
... o-rings and custom parts, so i understand your concerns about current data - ... import the Excel data to a temporary table. ... add the records to a permanent table. ... also, once you've set up the import, and the append query, once, you can use ...
(microsoft.public.access.forms) - Re: Append Query - Every 7 days
... On a side note if I put the calculated field anywhere except as the last ... "John W. Vinson" wrote: ... Once I grab the data from the form to use in an append query, ... Create a query based on Num, with a criterion on N of ...
(microsoft.public.access.queries) |
|
