ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel to Access *.MDB conversion (https://www.excelbanter.com/excel-discussion-misc-queries/67749-excel-access-%2A-mdb-conversion.html)

[email protected]

Excel to Access *.MDB conversion
 
I may well have missed this - but is it one of the options.
It's only a flat-file - a list of names and addreses to set up as a
mail-merge (producing memberhip cards (double-side).

I got a shareware proggy down which looks most suitable with the one
hitch (I hardly thought of it so at the time) of accepting Access file
as input-file.

Our registrar uses excel quite proficiently and can squirt the
newmember over the wires fine to the person printing the cards and
stuffing the envelopes.

I don't especially want to force beople to get used to (and perhaps
purchase if they don't have office - only excel) a new application
when not necessary.

An alternative I suppose is a membership-card-producer that accepts
excel (or CSV or DBF etc) if you know of one - but that hardly seems
the question to put here.

A thought that occurred is an email to the above chaps !! - I shall do
that as well

thanks for any pointers

Keith

Dave O

Excel to Access *.MDB conversion
 
Greetings from Virginia, USA, near Washington DC.

The jump from Excel to Access should be clean and straightforward,
particularly if the Excel file is a flat file. If you'll open an
Access database, from the Tables view click New and then select Import
Table from the window. Choose the location and specify the .XLS
format, and the Excel file should appear in the Tables view.

If I may suggest, open the table after the import to make sure that
things have gone the way you prefer. From your description, though, it
should be easily done.



All times are GMT +1. The time now is 06:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com