Importing Access table as it is.

Please do someone reply.
for Experts like you i think this little query must be really easy.
please do guide me.
thanks again

You need to change the With ActiveSheet line as shown below

Please Login or Register  to view this content.

Thanks Huron the User Prompt to select filename worked.

but now it is giving some error at last.

Run-Time Error '1004'
general ODBC error.

Where am i going wrong??

when i DEBUG it, this line of the code gets highlighted.

Please Login or Register  to view this content.

please let me know what little tweak is needed.
and thanks a million

Try this. Some of what I am doing I am sure is not exactly proper, but complete documentation on ADO seems a bit lacking. This is much more flexible than trying to use QueryTables and you just use a SQL query. Modify to suit your needs. Please note the query used here will return the ENTIRE TABLE. If it is quite large, you may want to narrow that down some.

Please Login or Register  to view this content.

Do the other databases have the same table and field names? The code refers to Frame Section Assignments.Line etc. If the databases are different, this part of the code will need to be changed.

HUron:
database has the same column headers.
that is Story , Line , Line Type etc. etc.
i dont know where exactly the code is going wrong.
hmm

MARZUK:

i tried the code which you have given but it gives some error as well...

it says
arguments are of the wrong type, are out of acceptable range, or are in conflich with one another

MARZUK AND HURON:---
i am attaching the MDB file which i am using.
all my future mDB files will have the tables having same headers.
http://www.4shared.com/file/15976772...e1/R1_MDB.html

hope you help me with this one
-- SSP

I think this should work

Please Login or Register  to view this content.

I've tried it on your database and it worked for me.

Thanks a million Huron !!!
it worked like a charm !!


i think even i should start learning VBA / Macro from scratch !! its very interesting.

and thanks a lot again!
you saved a lot of work.
-- SSP

P.S.: can you suggest any good books which might be a good start for a beginner like moi to start learning macro.

I'm glad it worked.

I can't really recommend any books - I've just learned most of what I know (which isn't very much!) by recording macros and adjusting them afterwards with help from the F1 key and Google.