From Excel to Access

[Sipozove]

Hello everyone!
I consider myself as a MS Excel geek.
And since some people tell me that too, it must be true.
I have fun with it whenever I need to manipulate data.

Then come the two big problems with spreadsheets: multi-users and data protection.
I'm sure some of you had some disasters too :-(
The only solution is database and MS Access is accessible.

So here I go

For now I've only built 3 little splitted databases.
Right now I'm working on a new one that could include those 3 later on.
I have some success and some failure but everything is an experience.

 

[Jon]

Welcome to the forums! We are the most active Microsoft Access community on the internet by far, with posts going back over 20 years!

To get started, I highly recommend you read the post below. It contains important information for all new users to this forum.

https://www.access-programmers.co.uk/forums/threads/new-member-read-me-first.223250/

We look forward to having you around here, learning stuff and having fun!

 

[theDBguy]

Hi. Welcome to AWF!

 

[AngelSpeaks]

Welcome to AWF!

 

[conception_native_0123]

welcome zove.

 

[Sipozove]

Thanks!
Very good start

 

[oleronesoftwares]

Welcome @Sipozove to the best online forum for Ms. Access Developers.

 

[The_Doc_Man]

Hello and welcome to the forum. I see you have a link from Uncle Gizmo, who is one of our members more experienced in such conversions as you described. His blog should be a good starting point.

 

[Sipozove]

I'm reading it.
I can relate many things ;-)
My biggest struggles are the some function don't work the same way (DAvg!) and I have to tweak it so it works correctly.
Then come the way I have to split a whole spreadsheet into many tables with relations. Not the technical aspect but more the thought process.
And once I think it's good and use it in production, I hope I won't have to modify anything...