How to create an Acces file using excel files

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Office 2003.

I have about ten Excel files listing Postcards I own. I sometimes used
different column headings for similar objects in those Excel files. For
example, I may have used "CardID" as a column header in one Excel file and
"Description" for the same purpose in another Excel file. I want to create a
new Access file which which would be automatically developed using the Excel
headers but I would also like to contain similar objects - data in only one
of the dilienated fields. That is the data in the column for "CardID" in
Excel file one would be imported into the "Description" field of the Access
database. Even more problematic for me is that the Import Wizard doesn't
work and in trying to correct the language tool an error message comes up
saying I don't have that "patch". At a minimum I would like to get the data
from the Excel files into an Acess file (whether created automatically or one
I would create manually). It used to be easy under earlier version of office,
but Microsoft seems to have a competitive process in play between their more
brainy programmers to determine who can outdo each other in obfuscating what
should be a relatively simple procedure. I suppose it keeps some of the
hackers off the streets of Washington.
 
Use Navicat
do google search


LoutheJew said:
I am using Office 2003.

I have about ten Excel files listing Postcards I own. I sometimes used
different column headings for similar objects in those Excel files. For
example, I may have used "CardID" as a column header in one Excel file and
"Description" for the same purpose in another Excel file. I want to create a
new Access file which which would be automatically developed using the Excel
headers but I would also like to contain similar objects - data in only one
of the dilienated fields. That is the data in the column for "CardID" in
Excel file one would be imported into the "Description" field of the Access
database. Even more problematic for me is that the Import Wizard doesn't
work and in trying to correct the language tool an error message comes up
saying I don't have that "patch". At a minimum I would like to get the data
from the Excel files into an Acess file (whether created automatically or one
I would create manually). It used to be easy under earlier version of office,
but Microsoft seems to have a competitive process in play between their more
brainy programmers to determine who can outdo each other in obfuscating what
should be a relatively simple procedure. I suppose it keeps some of the
hackers off the streets of Washington.
Click to expand...
 
Dear rgdelarosa,

I finally did succeed in downloading Navicat, and I am
sure that by using that program I would attain my stated
objectives. But you must have confused me with one of
those smartyboy, fancy-smancy members of my tribe.
Unfortunately, I am only your average beaner, perhaps
with an IQ of 119 (same as JFK and he was good enough for
me)so there would be a greater chance of me getting a
highball in heaven than understanding the what, the who
(I know the why is to help me solve my database issues)
and the howdy do of using that delightful program.
Nevertheless, I do appreciate that you responded to my
plea. Perhaps, one day the brilliant boy(s) from
Microsoft will realize that he (they) has a large and
distinct constituency of haters that has developed solely
due to his seeming unconcern which comes across as
arrogance and disregard for the public he claims to
serve.

Lou, just one of the average few
 
Hi Lou,

The general technique is to import or link each Excel table separately,
and then use append queries in Access to move the data from the separate
tables with their different field names into the final table.

Without a much clearer description I can't suggest what might be your
problem with the spreadsheet import wizard, other than the way it gets
confused by fields that contain both text and numbers (which happens in
all versions of Access). But the first step must be to install Service
Pack 1 for Office 2003 if you haven't already done so.

Often the best approach is to export from Excel to a CSV or
tab-separated text file, and then import that into Access.
 
Back
Top