Import Single File into Multiple Tables (Access 2003)

[James]

Hi All,

I would like to import a single file that will go into a temporary
table (I'll be purging this table when it reaches a certain thresholds
(age of records or number of records)). To keep my example simple
I'll use a import file of 10 fields. I would like 5 fields to go into
table A and other 5 in table B. I appreciate your help in advance.
Thanks.

 

[John Spencer]

It depends on what the file is and its structure.

If you can import into a temporary working file, you can always use append
queries to copy some of the fields into a different tables.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

 

[John W. Vinson]

Hi All,

I would like to import a single file that will go into a temporary
table (I'll be purging this table when it reaches a certain thresholds
(age of records or number of records)). To keep my example simple
I'll use a import file of 10 fields. I would like 5 fields to go into
table A and other 5 in table B. I appreciate your help in advance.
Thanks.

I'd suggest just linking to this table (rather than importing it), and run two
Append queries selecting the appropriate fields.

If you could describe the structure of the file, the tables, and what the
fields mean perhaps someone could give more specific advice.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[a a r o n . k e m p f]

Access doesn't have temp tables, sorry

move to SQL Server if you want to do this

 

[Bob Quintal]

"a a r o n . k e m p f @ g m a i l . c o m" <[email protected]>
wrote in
m:

Access doesn't have temp tables, sorry

move to SQL Server if you want to do this

m o r o n . k e m p f does not know anything about Access.

It takes a very few vb statements to create a temporary table and a few
more to delete it. when done.

 

[Douglas J. Steele]

It takes a very few vb statements to create a temporary table and a few
more to delete it. when done.

Even better is to create the temporary table in a temporary database. Tony
Toews has an example at http://www.granite.ab.ca/access/temptables.htm

 

[a a r o n . k e m p f]

yah.. because everyone needs _FOUR_ tiers of jet bullshit to duplicate
what's available in SQL Server, huh?

 

[a a r o n . k e m p f]

IT TAKES LIKE TWO WORDS TO DO IT IN SQL, AND IT CLEANS UP
AUTOMATICALLY AFTER ITSELF

re: It takes a very few vb statements to create a temporary table and
a few
more to delete it. when done.