Does a Freeware MS ACCESS database program (from my EXCEL worksheet) exist?

Question

Must I buy MS Access (I am a student). I need to take an excel spreadsheet and convert it into MS Access format. But I dont own Access database from MS.

Is there a freeware option for me?

I must create an access file format as I have to use ODBC from another program to do some data manipulation for a project.

Thanks!

Answer 1

try openoffice.org; it is very compatible with ms office.

Answer 2

If you have excel, then you have office. MS Query allows for word, excel an other office applications to load data from other sources such as: excel, a database (w/ odbc driver) or text file.

Use MS Query that comes with office, you will have to find the executable file (in window's explorer)
'msquery32.exe'
usually in
C:\Program Files\Microsoft Office\Office ,
right click on the exe and select 'send to'-> desktop, this will create a desktop icon

If you can't find it, run the office setup from cd and select add/remove
select 'Data Access'
click 'change'
put a check next to 'ms query ...'

see:
http://www.exceluser.com/explore/msquery1_1.htm

see this text to see MS Query used in Word:
http://www.unl.edu/sisteam/word97s2.html

to install: http://www.microsoft.com/technet/archive/office/office97/reskit/office97/027.mspx?pf=true

Answer 3

no longer promptly. do this:- ascertain the Microsoft Excel information is in record format: each and every column has a label contained in the first row and consists of similar info, and there aren't any clean rows or columns interior the record. close the Excel workbook that consists of the information you want to apply in Microsoft get proper of entry to. In get proper of entry to, open the database the position you want to reproduction the Excel information. on the get proper of entry to document menu, element to Get exterior information, and then click Import. contained in the Import talk field, click Microsoft Excel contained in the information of want field. contained in the look in record, hit upon the document you want to import, and then double-click the document. stick with the instructions contained in the Import Spreadsheet Wizard.