• 0

Turn my xls file into executable db application


Question

I have an excel sheet with 9 Fields.

It is like a customer database I put together. Anytime I have a new customer I add it there, and other fields are like phone number, person, address, email and notes.. that sort of thing.

I tried to move this into access but I cannot turn it into an executable. I just want this file to be the source of database, these fields can be used as columns. I can probably easily assign each a number to be the key value, and I would like phone number to be key on the db application.

What are your suggestions? It should be fairly easy. I have VB6 knowledge, but I am not sure if I remember enough to turn it into a db that retrieves info from xls.

Just wanna do some brain storming here, because I hate opening the xls every time and CTRL+F to find the customer I want to update..

8 answers to this question

Recommended Posts

  • 0

why cant you just create a blank database in access then do file > get external data > import ? obviously you would have to sort out relevant tables , primary keys etc but yeah just import the data since its in an excel spreadsheet. You dont really need to keep the spreadsheet anyway better off having it in access.

  • 0

you may have to split the spreadsheet into several smaller ones using normalisation. Ideally you want your spreadsheet in 3rd normal form. More than likely your spreadsheet as it is will be in 1st normal form, maybe not even that Once youve done normalisation on the spreadsheet to 3rd normal form you will have the required tables. Once you know what data has to go into each table, you can then split the spreadsheet up appropriately into the required tables, then go into access and build the tables or for each table import the data from the smaller spreadsheets. Once the data is imported you can setup relationships and your primary/foreign keys (maybe need a composite key) so that the database functions correctly. so for example split the spreadsheet into customers (customer data), orders, products.

Hope that makes sense sort of. Look at google for normalisation, entity relationship diagrams, importing data into access. Access will import the data theres just alot more to it than simply importing data.

  • 0

Thanks for both of your answers. I am not looking for an advanced setup, it has been a long time since I took access classes.

I think easiest way to do would be as following: I found out that pre-defined "Contact Management" DB in Access would be suitable for me, with a slight modification.

I went to Tables under Objects, and clicked on Contacts table. I added new Column, and gave it a new name (let's call this brand) .

Now, If I want this column's information on form view, how do I add new field into the form that retrieves information from table's new "brand" field.

I went into form design, but when I got to Database View instead of Form Design, the new column is not showing up there. How do I bind this new text field to new column?

Thanks.

  • 0
  Grogi said:
Select text box

Press F4

Data/Control Source

...

Select table under 'Tables' and column you want

Thanks. I fiddles with it and that's where I got, under DATA tab.

Thanks for your help, I figured out what I need to do.

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.