Hi,
I have a TransferSpreadsheet Macro where I import a spreadsheet on click of a command botton.
The settings are
Transfer Type: Import
Spreadsheet Type: MS Excel 5-7
Table Name: XYZ
File Name: C\Documents and Settings\Home\MyDocuments\XYZ.xls
Has Feild Names: Yes
Range: (nothing)
Is there anyway of importing this spreadsheet & automaticlly assigning a unique ID feild with an AutoNuumber Data Type or does an ID feild have to be added in the spreadsheet first ???
Also can you automatically assigne a Primary Key via this same macro ? or do you do it manually after import.
Thanks for any help or ideas.
I have a TransferSpreadsheet Macro where I import a spreadsheet on click of a command botton.
The settings are
Transfer Type: Import
Spreadsheet Type: MS Excel 5-7
Table Name: XYZ
File Name: C\Documents and Settings\Home\MyDocuments\XYZ.xls
Has Feild Names: Yes
Range: (nothing)
Is there anyway of importing this spreadsheet & automaticlly assigning a unique ID feild with an AutoNuumber Data Type or does an ID feild have to be added in the spreadsheet first ???
Also can you automatically assigne a Primary Key via this same macro ? or do you do it manually after import.
Thanks for any help or ideas.