Data import utility

[John]

Hi

From time to time we are required to import external data into our access
app. I am wondering if there is any utility available for this purpose. What
we need is a) mapping of fields between access table and external data and
b) duplication test on user specified combination of fields.

Any recommendations would be appreciated.

Thanks

Regards

 

[John Mishefske]

From time to time we are required to import external data into our access
app. I am wondering if there is any utility available for this purpose. What
we need is a) mapping of fields between access table and external data and
b) duplication test on user specified combination of fields.

Take a look at Metamorphosis on my website. It meets most basic
requirements.

http://tigeronomy.com/Code.aspx

--
John Mishefske, Microsoft MVP 2007 - 2009
UtterAccess Editor
Tigeronomy Software
web: http://www.tigeronomy.com
email: sales ~at~ tigeronomy.com

 

[aaron.kempf]

**** you whore, don't reccomend your commercial apps.. this usenet
group only allows you to post _FREE_ things.. you're a spammer.. ****
you spammer, stay the **** out of this FREE newsgroup

 

[aaron.kempf]

Learn a real ETL tool-- like DTS or SSIS

Jet is ****ing stupid, it doesn't have the basics of any professional-
level ETL tool
Jet doesn't support code reuse

 

[Tony Toews [MVP]]

Learn a real ETL tool-- like DTS or SSIS

Jet is f***ing stupid, it doesn't have the basics of any professional-
level ETL tool

Of course not. That's not it's job. And nether is basic SQL Server.

Jet doesn't support code reuse

Another totally incomprehensible comment. Are you regurgitating buzzwords in the
hope that they will baffle the readers?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[aaron.kempf]

why do you insist that people use Access for ETL, when it doesn't
include basic ETL capabilities?
why do you insist that people use Access for ETL, when it doesn't
include basic ETL capabilities?
why do you insist that people use Access for ETL, when it doesn't
include basic ETL capabilities?
why do you insist that people use Access for ETL, when it doesn't
include basic ETL capabilities?

WTF is wrong with you?
WTF is wrong with you?
WTF is wrong with you?
WTF is wrong with you?

 

[Gina Whipp]

John,

Not sure if you go an answer to your question so I'm here to tell you what I
do... I needed to bring in EDI files and map them a several tables in an
Access database. Of course, this only works if there is a Prmary Key. I
set it up so when the database opens it transfer the file (that I set up to
export once files are recieved EDI). There is also a button one can press
should they want to check that they have the most current transaction.
Would something like that work for you?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm