> Thanks for ur help
>
> As MS Access support upto 2 GB of Database file size we designed &
> splited our database. Besides our database contains interlinked data also.
>
> So Now we want to use the same database (Import Data). Is there any
> other options?

Put everything onto 1 database... :-)

From what I can read in your message, it's all related anyway and you
actually worked around a physical limitation in Access.

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com