Imported Excel table to Access Forms?

[Brenda]

An excel worksheet (with thousands of records and many fields) has been
imported into Access as one table. Ideally, I'd like to access or query
select fields with accompanying data (i.e. customers, books). Is there a way
to perform this without entering the individual records for each Field into a
Form?
Kind Regards,
Brenda

 

[pietlinden]

An excel worksheet (with thousands of records and many fields) has been
imported into Access as one table. Ideally, I'd like to access or query
select fields with accompanying data (i.e. customers, books). Is there a way
to perform this without entering the individual records for each Field into a
Form?
Kind Regards,
Brenda

You said it yourself. QUERY.
If you want to split the data out so that you have more than a
glorified spreadsheet, you would use queries to append the data to
various tables.

 

[Brenda]

Pietlinden thanks for letting me know that my initial inclination is at least
correct. I had designed several tables and created relationships in hopes of
appending the data from the spreadsheet-table. Perhaps I went about the
process wrong. I'd appreciate if you could help me along with steps. With the
Table open, how should I progresss? I'm new to this, thanks for your patience.

 

[Brenda]

FYI, I'm using Access 2003 and I'm not sure if this makes a difference but
some of the cells in my worksheet-table are without data. Thanks.

 

[Peter Hibbs]

Brenda

Try the Excel to Access Converter Utility, you may find it easier to
use. Go to http://www.rogersaccesslibrary.com/index.htm and click on
Other Developers Libraries, you will find it there under Hibbs PeterS.

Peter Hibbs.

 

[Brenda]

Peter this looks like a much easier process! I will be able to try it out
this afternoon. Another concern... according to your directions, I might want
to export my resulting tables to a new database via .csv files (perhaps for
greater efficiency or a cleaner slate). How might I actually find and
accomplish a .csv transfer? I appreciate your guidance.

 

[Peter Hibbs]

Brenda,

When you have created your .csv files using the utility program and
saved them to disk you can run your database program, click on File ->
Get External Data -> Import...
In the File Selector change the Files of Type: field to :-
Text Files (*.txt, *.csv, *.tab, *.asc)
Locate your .csv files and click Import.

As it says in the documentation, if you are importing data to several
related tables you need to import them in the correct order, i.e.
primary key tables first and then foreign key tables. Incidentally,
you don't necessarily need to start a new database, if you have
already created your database you can import into the existing tables
(make sure you have deleted any existing records and also ensure the
field names match the ones you used when creating the .csv files).

If you have any problems just post back or email me direct.

Peter.