I'm trying to convert Excel spreadsheets into MS Access Database.
Basically, this will be one large table from what I can see so far.
And not multiple tables. Feel free to educate me on one large table
vs multiple tables and databaes if you have time.

I'm having problems importing spreadsheets into the one table. It
keeps giving me errors with the column heads "Field 'abc_' or '_abc_'
doesn't exist in the destination table".


Do this "_" underscore means there is a space being imported over?

Thanks..a million...

I usually open Excel.. grab the first row.. and then find and replace
spaces with underscores



On Feb 1, 1:15*pm, Ty <tyrone_... (AT) yahoo (DOT) com> wrote:

On 01/02/2011 21:15:07, Ty wrote:
Not sure why the underscores are giving a problem. Why not change the column
heads and see if that works. You have not made it clear whether you are
making a new table or appending data to an existing table, in which case you
will need matching field names.

As to the subject of mutiple tables.
IMO if you have the same bit of data over about half a dozen times, then make
a table for it. E.G. if you are involved with names & addresses and you have
a number of people living in the same town, then have a Town table. If you
have a Town table, you certainly would want a County Table, and even if you
don't have a town table you may still want a County table.
Whats the advantage?
If you just type an adddress in, and the person lives in the town of
Shrewsbury, is the county Shropshire or Salop or Salop. (with a full stop)?
Doing a search for a county then becomes difficult. The only common letter is
S, but so do Somerset, Staffs, Surrey & Sussex. If you use a lookup for your
counties from a town form, then you can only have Salop if that is the way
the name is held in the County table. And, furthermore, if you change Salop
to Shropshire in the County table, every address will change to match. Phil

On Feb 2, 10:12*am, "Phil" <p... (AT) stantonfamily (DOT) co.uk> wrote:
Thanks for the responses... I imported one spreadsheet(spreadsheet
#1) into Access(a table) and then started to append the other
spreadsheets(spreadsheet #2) to the first spreadsheet(a table). The
underscore is not displaying in the Excel spreadsheet. MS Access has
to be seeing a space or extra character or something that is not
displaying in MS Excel.

What I did was just erase the column head and re-typed it in the
first. I have 7 spreadsheets. My plan is to just copy and paste the
head of each column from spreadsheet #1 to all spreadsheets and any
future spreadsheets.

Phil, thanks for the multiple table 101 database explaination. I'm
still trying to remember databases and wrap my brain around
databases. It has been a while. It will take some time to get up to
speed.