Export data to Access

[AnnPhil]

Is there a way to export data from an Excel spreedsheet into Access? I know how to import from Access but i need to do it from Excel. Thanks

 

[GaryPanic]

I don't think you can

you can save as certain file types - but thats as far as it goes .


i think you can link a xls sheet to access
but in essessen it easier to import from access

 

[AnnPhil]

I agree with you but for reasons that would take to long they want to do it in Excel, I didn't think you could but thought i would throw it out to the group to see if there was something i might have missed. Thanks

 

[GaryPanic]

it might be do-able - but you would need someone who actually knows what they are talking about -
they guys here know access to a high degree and are experts - but Excel ?
have you tried xls help files -
- Personally I don't think its do-able
you could do a get round but thats probably more complicated

and would involve link sheets /workbooks

in essense have access -link to a spreadsheet have that spreedsheet the target of your xls links- but even this is gonna be prone to all sorts of cockups- and not so easy to manage

you could have a routine that automatical imports a target xls - but again you are doing this from access and not from xls

 

[GaryPanic]

I have had a quick look and the help files don't help at all - i presume its not do-able-

however there is a software solution that can be purchased that says it can do this - but to be honest it looks like a variation of Ghudsons import solution - and again seems to be from Access end .


regards

 

[unmarkedhelicopter]

This is eminently doable ...
We can connect to an access database using ADO or DAO and fully manipulate the database (.mdb)
It's typically done when you want a multi-user database with an Excel front end.

Though it does depend on what you actually want to do with it.

 

[GaryPanic]

i stand corrected (lol)

I knew you could have a xls connected to a access d/b -
didnt realsie you could start en export from xls..-
every day you learn something new

 

[AnnPhil]

Thats good to know unmarkedhelicopter, not sure how to do that, not much of a programer but have done some, can you tell me how to get started?

Thanks

 

[unmarkedhelicopter]

Here is an example :-
http://www.puremis.net/excel/cgi-bin/yabb/YaBB.pl?num=1143633690

 

[AnnPhil]

Thanks i will take a look at your link