create database from excel data

  • Thread starter Thread starter stephen.ditchfield
  • Start date Start date
S

stephen.ditchfield

hello, I have an XP excel file with 21000rows & 20columns of athletic
results. at the moment all I do is an auto filter on an athletes name
to get all of their records displayed. Is there a way I could convert
to XP access to have the data available through the web.NOT very
competant with XP access.
any thoughts or help appreciated,
regards
Ditchy
Ballarat Vic Aus
 
If the Excel spreadsheet is laid out in a simple tabular format without
blank rows or columns then it can be easily imported into Access - choose
'Get external data ...' from the File menu. If it does contain blank rows or
columns, or other spreadsheet features such as graphics and charts, you
might want to create a copy of the spreadsheet and remove those before
trying to import.

There may well be significant work remaining to be done after the import,
though. A good spreadsheet design is not necessarily a good database design,
and transferring the data to a database is just one small step in the
process of creating a data-centric web application.
 
If the Excel spreadsheet is laid out in a simple tabular format without
blank rows or columns then it can be easily imported into Access - choose
'Get external data ...' from the File menu. If it does contain blank rows or
columns, or other spreadsheet features such as graphics and charts, you
might want to create a copy of the spreadsheet and remove those before
trying to import.

There may well be significant work remaining to be done after the import,
though. A good spreadsheet design is not necessarily a good database design,
and transferring the data to a database is just one small step in the
process of creating a data-centric web application.

--
Brendan Reynolds






- Show quoted text -
Click to expand...

Thanks Brendan
yes there is a few blank rows, I think I have a lot of work in front
of me.
I will need to work out what design I actually need
regards
Stephen
 
Back
Top