Import Or Link: Excel

[Guest]

I have a Excel table and I need to link to or import into Access table.
This excel table is as follows:
Emp_num Supervisor User ID1 User Key1
John Doe 234
6546 Bill 434 878
Tom
66556 Salas 343 87
765 Canto 9834932

Q1. How can I write an Excel procedure to fill in all blank cells (mixed
datatype) before Importing or Linking? If empty cell are C1 (Text DataType)
and E4 (Number Datatype), '-31 and -54 will be entered with consideration of
datatype.
Q2. Link or Import? Which is better and why?

Thank you very much.

 

[John Vinson]

I have a Excel table and I need to link to or import into Access table.
This excel table is as follows:
Emp_num Supervisor User ID1 User Key1
John Doe 234
6546 Bill 434 878
Tom
66556 Salas 343 87
765 Canto 9834932

Q1. How can I write an Excel procedure to fill in all blank cells (mixed
datatype) before Importing or Linking? If empty cell are C1 (Text DataType)
and E4 (Number Datatype), '-31 and -54 will be entered with consideration of
datatype.

Probably easier to do it first though you could do it either way.

Q2. Link or Import? Which is better and why?

Each is better than the other in the appropriate circumstances <g>.

If the spreadsheet is "live", being edited independent of Access, then
linking lets you connect to the most up-to-date data. If you're
worried about bloat in the Access database and you'll often be using
different Excel data, then linking leaves the Access database
unaffected.

On the other hand, if you'll be using the Excel data intensively, and
even more so if you'll be updating it, Importing will give you much
better performance and allow you to manage the data however you like,
independent of the spreadsheet.

John W. Vinson[MVP]