|
 |
access thread: Map Fields from Excel to Access then Import
Message #1 by "George Oro" <george@c...> on Tue, 28 May 2002 13:23:16 +0400
|
|
Hi Guys,
I don't know if this is possible.
For instance I have a table called tblMyContact with the following fields:
fldContactID
fldFirstName
fldLastName
fldCompany
fldJobTitle
fldEmail
etc...
Then a Number of Excel file with different field format or column name, containing a lot of contacts.
My idea is from my AccessDB I will just browse the excel file from my HD then map whatever fields related to my tblMyContacts then
Import the data.
Make sense? Its seems like a utility wizard.
Cheers,
George
Message #2 by Omar Chaudry <OChaudry@b...> on Tue, 28 May 2002 11:10:37 +0100
|
|
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C2062F.E9EABD60
Content-Type: text/plain
You can link an excel sheet/range as a linked table in Access just choose
Excel as the file type when linking. Once linked you can perform the usual
DB operations on the table including browsing it through select statements
in forms etc and write queries.
HTH
Omar
-----Original Message-----
From: George Oro [mailto:george@c...]
Sent: 28 May 2002 10:23
To: Access
Subject: [access] Map Fields from Excel to Access then Import
Hi Guys,
I don't know if this is possible.
For instance I have a table called tblMyContact with the following fields:
fldContactID
fldFirstName
fldLastName
fldCompany
fldJobTitle
fldEmail
etc...
Then a Number of Excel file with different field format or column name,
containing a lot of contacts.
My idea is from my AccessDB I will just browse the excel file from my HD
then map whatever fields related to my tblMyContacts then
Import the data.
Make sense? Its seems like a utility wizard.
Cheers,
George
DISCLAIMER: The information in this message is confidential and may be
legally privileged. It is intended solely for the addressee. Access to this
message by anyone else is unauthorised. If you are not the intended
recipient, any disclosure, copying, or distribution of the message, or any
action or omission taken by you in reliance on it, is prohibited and may be
unlawful. Please immediately contact the sender if you have received this
message in error. Thank you.
Message #3 by "George Oro" <george@c...> on Tue, 28 May 2002 14:13:21 +0400
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0020_01C20651.D2DFDFC0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
RE: [access] Map Fields from Excel to Access then ImportOmar,
At the moment this what I'm doing as an Administrator Job, but I want to
avoid this and allow normal user's to do job without bothering them to
linked and create queries.
Thanks for the tips anyway.
Cheers,
George
-----Original Message-----
From: Omar Chaudry [mailto:OChaudry@b...]
Sent: Tuesday, May 28, 2002 2:11 PM
To: Access
Subject: [access] RE: Map Fields from Excel to Access then Import
You can link an excel sheet/range as a linked table in Access just choose
Excel as the file type when linking. Once linked you can perform the usual
DB operations on the table including browsing it through select statements
in forms etc and write queries.
HTH
Omar
-----Original Message-----
From: George Oro [mailto:george@c...]
Sent: 28 May 2002 10:23
To: Access
Subject: [access] Map Fields from Excel to Access then Import
Hi Guys,
I don't know if this is possible.
For instance I have a table called tblMyContact with the following fields:
fldContactID
fldFirstName
fldLastName
fldCompany
fldJobTitle
fldEmail
etc...
Then a Number of Excel file with different field format or column name,
containing a lot of contacts.
My idea is from my AccessDB I will just browse the excel file from my HD
then map whatever fields related to my tblMyContacts then
Import the data.
Make sense? Its seems like a utility wizard.
Cheers,
George
DISCLAIMER: The information in this message is confidential and may be
legally privileged. It is intended solely for the addressee. Access to this
message by anyone else is unauthorised. If you are not the intended
recipient, any disclosure, copying, or distribution of the message, or any
action or omission taken by you in reliance on it, is prohibited and may be
unlawful. Please immediately contact the sender if you have received this
message in error. Thank you.
--- Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to
Message #4 by joe.dunn@c... on Tue, 28 May 2002 11:38:18 +0000
|
|
Look at
http://office.microsoft.com/downloads/2002/acclnk.aspx.
for AccessLinks which is an Excel Add-In that may provide what you want
*************************************************************************
This e-mail may contain confidential information or be privileged. It is intended to be read and used only by the named
recipient(s). If you are not the intended recipient(s) please notify us immediately so that we can make arrangements for its return:
you should not disclose the contents of this e-mail to any other person, or take any copies. Unless stated otherwise by an
authorised individual, nothing contained in this e-mail is intended to create binding legal obligations between us and opinions
expressed are those of the individual author.
The CIS marketing group, which is regulated for Investment Business by the Financial Services Authority, includes:
Co-operative Insurance Society Limited Registered in England number 3615R - for life assurance and pensions
CIS Unit Managers Limited Registered in England and Wales number 2369965 - for unit trusts and PEPs
CIS Policyholder Services Limited Registered in England and Wales number 3390839 - for ISAs and investment products bearing the CIS
name
Registered offices: Miller Street, Manchester M60 0AL Telephone 0161-832-8686 Internet http://www.cis.co.uk E-mail
cis@c...
CIS Deposit and Instant Access Savings Accounts are held with The Co-operative Bank p.l.c., registered in England and Wales number
990937, P.O. Box 101, 1 Balloon Street, Manchester M60 4EP, and administered by CIS Policyholder Services Limited as agent of the
Bank.
CIS is a member of the General Insurance Standards Council
CIS & the CIS logo (R) Co-operative Insurance Society Limited
********************************************************************************
Message #5 by "George Oro" <george@c...> on Tue, 28 May 2002 14:52:48 +0400
|
|
Joe,
I'm using Access/Excel 2000, but I downloaded and install it. But how to use it?
Thanks for the tips, cheers.
George
-----Original Message-----
From: joe.dunn@c... [mailto:joe.dunn@c...]
Sent: Tuesday, May 28, 2002 3:38 PM
To: Access
Subject: [access] Re: Map Fields from Excel to Access then Import
Look at
http://office.microsoft.com/downloads/2002/acclnk.aspx.
for AccessLinks which is an Excel Add-In that may provide what you want
*************************************************************************
This e-mail may contain confidential information or be privileged. It is intended to be read and used only by the named
recipient(s). If you are not the intended recipient(s) please notify us immediately so that we can make arrangements for its return:
you should not disclose the contents of this e-mail to any other person, or take any copies. Unless stated otherwise by an
authorised individual, nothing contained in this e-mail is intended to create binding legal obligations between us and opinions
expressed are those of the individual author.
The CIS marketing group, which is regulated for Investment Business by the Financial Services Authority, includes:
Co-operative Insurance Society Limited Registered in England number 3615R - for life assurance and pensions
CIS Unit Managers Limited Registered in England and Wales number 2369965 - for unit trusts and PEPs
CIS Policyholder Services Limited Registered in England and Wales number 3390839 - for ISAs and investment products bearing the CIS
name
Registered offices: Miller Street, Manchester M60 0AL Telephone 0161-832-8686 Internet http://www.cis.co.uk E-mail
cis@c...
CIS Deposit and Instant Access Savings Accounts are held with The Co-operative Bank p.l.c., registered in England and Wales number
990937, P.O. Box 101, 1 Balloon Street, Manchester M60 4EP, and administered by CIS Policyholder Services Limited as agent of the
Bank.
CIS is a member of the General Insurance Standards Council
CIS & the CIS logo (R) Co-operative Insurance Society Limited
********************************************************************************
Message #6 by joe.dunn@c... on Tue, 28 May 2002 12:46:45 +0000
|
|
Whilst AccessLinks is from Microsoft, the following text is extracted f
rom
SMART ACCESS - this publication is so useful, I would recommend that yo
u
take out a subscription. See http://www.pinnaclepublishing.com/ for fur
ther
information.
AccessLinks is an add-in.
After downloading, you end up with ACCLNK.EXE. Run the executable to
install the add-in's file (AccLink.xla) to any directory that you want
and
then add AccessLinks to Excel via the Add-In Manager from the Tools |
Add-Ins dialog. You should find the Microsoft AccessLinks add-in in th
e
list . Check off the AccessLinks add-in on the list and then click on
OK
to integrate the add-in with Excel. The Excel Data menu will include t
he
following new items:
MS Access Form
MS Access Report
Convert to MS Access
The Convert to MS Access option takes a selected area of an Excel
spreadsheet and exports it to either a new or existing Access databas
e.
This is a one-way transfer and is intended to allow users to move an
application from Excel to Access permanently. One warning: When expor
ting
to an existing database, the wizard requires you to enter the full
pathname even if the MDB file is in the same directory as the Excel
spreadsheet.
Selecting the Convert to MS Access menu choice actually loads Access
into
memory and calls Access's Import command. The user is then walked thr
ough
Access's Import Wizard. This requires the user to answer questions ab
out
field size and type?not decisions that you'll want your users to make
in
a production system. Once you've finished exporting your data, howeve
r,
the resulting database is bound to the spreadsheet. If the user now w
orks
with either of the other two commands (MS Access Form or MS Access
Report), the resulting forms or reports will automatically be directe
d to
the same database.
The MS Access Report and MS Access Form menu choices both do roughly
the
same thing: start Access, insert a link to the data into the database
,
and start either the Form or Report Wizard. Again, you probably don't
want your users generating forms in a production system. However, giv
ing
users the ability to use the Access Report Wizard from within Excel m
ight
be a good idea. Once either process is complete, a new button is adde
d to
the spreadsheet for each form or report that's created. The Convert t
o MS
Database option also adds a text box to the spreadsheet documenting w
hat
database the spreadsheet is working with.
If a user clicks on one of the buttons that's been added to the
spreadsheet, Access is loaded into memory and the report or form is t
hen
run. If it's a form that's at the other end of the button, the user c
an
update or enter data from the form into the spreadsheet. If it's a re
port
that's loaded, the user gets a print preview of the report.
Once the link is established, you can use it from either Access or Ex
cel.
The reports and forms created by AccessLinks are, of course, limited
to
what you can create with Access's Form and Report wizards. However, o
nce
the forms and reports are created and linked to the Excel spreadsheet
,
there's nothing stopping you from modifying the initial forms - and,
with
the link made, you can add new forms and reports to the database. If
the
users don't need to get to this functionality from within Excel, you
can
delete the buttons from within Excel. If you want to leave the button
s in
place, it would be a good idea to replace their default caption ("Vie
w
Access Report") with the name of the report or form to run.
By running the add-in, you can quickly link an Excel spreadsheet to a
n
Access database. You can also generate a basic form or report from wh
ich
to begin your development using the add-in.
*************************************************************************
This e-mail may contain confidential information or be privileged. It is intended to be read and used only by the named
recipient(s). If you are not the intended recipient(s) please notify us immediately so that we can make arrangements for its return:
you should not disclose the contents of this e-mail to any other person, or take any copies. Unless stated otherwise by an
authorised individual, nothing contained in this e-mail is intended to create binding legal obligations between us and opinions
expressed are those of the individual author.
The CIS marketing group, which is regulated for Investment Business by the Financial Services Authority, includes:
Co-operative Insurance Society Limited Registered in England number 3615R - for life assurance and pensions
CIS Unit Managers Limited Registered in England and Wales number 2369965 - for unit trusts and PEPs
CIS Policyholder Services Limited Registered in England and Wales number 3390839 - for ISAs and investment products bearing the CIS
name
Registered offices: Miller Street, Manchester M60 0AL Telephone 0161-832-8686 Internet http://www.cis.co.uk E-mail
cis@c...
CIS Deposit and Instant Access Savings Accounts are held with The Co-operative Bank p.l.c., registered in England and Wales number
990937, P.O. Box 101, 1 Balloon Street, Manchester M60 4EP, and administered by CIS Policyholder Services Limited as agent of the
Bank.
CIS is a member of the General Insurance Standards Council
CIS & the CIS logo (R) Co-operative Insurance Society Limited
********************************************************************************
|
|
|
View Cart
