New to creating a database

Topic

New Reply

Hello everyone,

I am trying to create a database from an Excel spreadsheet. I looked at a couple of articles on how to convert an Excel spreadsheet to a database such as Microsoft Access and it looks fairly easy. With all the different types of database software that is out there, like Microsoft Access, MySQL and MS SQL Express, which database program should I use? Thanks in advance for any tips or knowledge.

Trinh4life

Reply | Quote

Replies

T4L,

Welcome to the Lounge as a new Poster! :cheers:

For someone new to databases, IMHO, I’d recommend you stick with Access and then move to one of the others if, and only if, you outgrow the capabilities of Access.

If converting from Excel make sure all your columns have Titles in ROW 1 (preferably w/o spaces) and that you have NO BLANK columns between your columns containing data.

HTH :cheers:

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

Thanks for the tips RG.

Reply | Quote