Re: Import multiple mdb files to SQL Server issue: Please Help...

Hi Allan,

I got your email, thanks for your response...
I know the file extension .res doesn't look like MDB but it is. We have to
use MS Access 2K or 2003 version to open. I currently have about 200+ .res
files need to be imported onto SQL Server database. These *.res files have
been generated from the 3rd party vendor system. There are 10 tables in each
..res file and all .res files have exactly the same table structure design,
except the data diff.

I'm very beginner for this task, so I need a lot of help...It's greatly
appreciated for any help.

Best regards,


--
NT


"Allan Mitchell" wrote:

Hello NT,


Got it thanks. Will look tonight
--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

Please check your email again...

"Allan Mitchell" wrote:

Hello NT,

remove no-spam

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com
|
http://www.konesans.com
I have sent to this address allan@xxxxxxxxxxxxxxxxxxx Is it right?

"Allan Mitchell" wrote:

Hello NT,

You will need to modify my eMail slightly to get it to work.

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com |
http://www.sqldts.com
|
http://www.konesans.com
Hi Allan,

I'm really bad...I still could not make it work even with a big
help from you. Here is my modification if you would help...Thanks
buch! I sent my .dts to your email

Thanks,

"Allan Mitchell" wrote:

Hello NT,

So your loop simply changes to looping over MDBs
Your assignment of found MDB changes to be a different type of
connection.
You remove the FF --> SQL Server and replace with Access --> SQL
Server
Hopefully this should get you started
--
Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com |
http://www.sqldts.com
|
http://www.konesans.com
Hi Allan,

I've used the sample package from http://www.sqldts.com/246.aspx
as you suggested. This package works well for the source data
in flat text format. Unfortunately, in my case that I'm dealing
with the source data in MS Access format. Perhaps, I don't know
to convert this package to work for MS Access files.

Thanks very much if you would get me more and/or better hints on
this issue.

"Allan Mitchell" wrote:

Hello NT,

You can easily convert this package to do what you want

http://www.sqldts.com/246.aspx

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com |
http://www.sqldts.com
|
http://www.konesans.com
Hi All,
I have about 100+ mdb files with the same table structure
design;
need
to be
imported into SQL Server. They are in the same directory but
separated
sub-folders (ex: d:\MTS\A1\*.mdb files and d:\MTS\A2\*.mdb
files....d:\MTS\A...n\*mdb files)
I've created the DTS package to import but it handles only one
file
for each
package. It's impossible for me to create 100+ DTS packages
with
the
actual
source filename. Please help, I'm greatly appreciated for your
help.
Sincerely



.

Relevant Pages