Huge Excel spreadsheets to Access. How?

[Anon]

Hello,

I'm quite new to databases, and I hope to get some help from you guys. I have a huge and complex (I mean there are references from one sheet to another one) Excel workbook. I would like to convert the whole thing into an Access database where all these references are kept. Is it possible at all? Or is it evident and I should stop asking stupid questions? Anyway, please help me with your ideas. Thanks a lot in advance!

Bye,

Akos, Hungary
E-mail: [e-mail]

[tasistro]

How bout posting it in an Excel Acces Forum not a php one.

[gmarton]

Akos,

Open Access
Make new database (save it too)
Go to File>>Get External Data>>Import
Set files of type to MS Excel
Navigate to where your .xls file is
Import it

Voila!
If your excel file is REALLY big i suggest you use SQL or mySQL or someting other than Access.

Ezzel nekem is volt gondom 🙂

Gyurci