Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

using Multiple text files (csv) to create one tingle table

Status
Not open for further replies.
sol1

sol1

MIS
Nov 20, 2003
4
AU
What is the best solution in MS Access where I have multiple text files (csv) that change on a monthly basis and I wish to place them in one table. I have been advised a UNION query may be best. To ate, I have NOT used a Union query

All the text files have the same fields

Thanks
 
Status
Not open for further replies.

Similar threads

RJKumar
  • Locked
  • Question
How to build Dimensional model for commission received and return
Replies
1
Views
250
johnherman
johnherman
Ulianna
  • Locked
  • Question
Loading files from different sources into one database table
Replies
1
Views
112
johnherman
johnherman
dshivhare
  • Locked
  • Question
FACT table with Timezone
Replies
1
Views
228
johnherman
johnherman
Edward1984
  • Locked
  • Question
Data mining in text logs: associating sentences with each other
Replies
2
Views
193
Edward1984
Edward1984
Vivarto
  • Locked
  • Question
Attributes of two dims in an N dim fact table
Replies
3
Views
205
blom0344
blom0344

Part and Inventory Search

Sponsor

Back
Top