PC Review


Reply
Thread Tools Rate Thread

How to Append Table with file and add a field with file name

 
 
Mary
Guest
Posts: n/a
 
      11th Sep 2009
I am appending an Excel Sheet to a table in Access. There are many files to
Import in and I would like the file name to go into a field of each record
appending in because the file name contains a date. I need this date to
reference the detail of the record. How do I get an import script that adds
the file name to that field in each record being appended in?
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
append file name to a table GEORGIA Microsoft Access Macros 8 25th Sep 2009 06:38 PM
Append query - Append to table with Autonumber field Boon Microsoft Access Queries 2 29th Jun 2009 06:23 PM
Append csv or xls file to existing table RitchieJHicks Microsoft Access External Data 3 4th Nov 2008 12:29 PM
import and append excel file to main table and sub table socasteel21 via AccessMonster.com Microsoft Access Queries 9 26th Jun 2006 03:32 PM
re:Help to append flat file table to two tables Vika Microsoft Access Queries 1 26th Sep 2005 05:30 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:57 PM.