-3

My requirement is to add a blank table onto a Form in MS Access 2003 on which I can paste the data copied from the excel sheet. This table need to have the same column structure as excel sheet.

But I am unable to find any UI component which can do this task.

Jagu

Erik A
  • 31,639
  • 12
  • 42
  • 67
Nuclear - Core
  • 159
  • 1
  • 2
  • 9

1 Answers1

0

First step, you need to create a table with same columns data type in same order than excel

Then create a form for this table allowing datasheet view.

when you open this for in data sheet view, you can past records from excel. For this first copy excel records to clipboard and then right click on asterisk (*) in access form (datasheet view) and paste.

Horaciux
  • 6,322
  • 2
  • 22
  • 41