How to import several csv files into 1 access table?

  • Thread starter Thread starter Chris Silvey
  • Start date Start date
C

Chris Silvey

I have several csv files from 4 distributors and I wish to compile all the
data into one table and export it to csv format to upload on a production sql
server.

all files contain similar field names, such as MFGPartNumber,
ManufacturerID, ManufacturerPartNumber. Would I have to change the field
names manually in the spreadsheets to match my access field name? or is there
a way to have MFGPartNumber=ManufacturerPartNumber in some kind of formula?

I am very new to this and any help would be appreciated.
 
I'd probably link a CSV file from each of the distributors. Next create an
append query to your master table based on that linked CSV file. Then save
each of the queries for future use.

Then you would only need to change the name (or make a copy) of the CSV file
from a distributor to match what the table link is expecting.
 
Chris Silvey said:
I have several csv files from 4 distributors and I wish to compile all the
data into one table and export it to csv format to upload on a production
sql
server.

all files contain similar field names, such as MFGPartNumber,
ManufacturerID, ManufacturerPartNumber. Would I have to change the field
names manually in the spreadsheets to match my access field name? or is
there
a way to have MFGPartNumber=ManufacturerPartNumber in some kind of
formula?

I am very new to this and any help would be appreciated.
Click to expand...
 
Looking for any one who knows how to set up windows live email.
Is it pop3?
and what to put in out going server and incoming server
 
I have a couple of suggestions for you...

(1) ask questions about Windows Live Email in a newsgroup with
that as its subject and concentration -- this one is about Microsoft
Access database software.
(2) when you have a new question, as you do, don't post it as a
response in a thread of messages about a different subject, because
it is likely to get lost, completely.

You will find some newsgroups dealing with Windows Live in the hierarchy of
Microsoft-sponsored newsgroups. User your newsreader to search for them.

Larry Linson
Microsoft Office Access MVP
 
Back
Top