Re: Generate create table SQL from excel 2007

[Jim Oberholtzer <midrangel@xxxxxxxxxx>]

It's been so long since I used that function that I forgot about it.  
Thanks for the reminder!

Jim Oberholtzer
CEO/Chief Technical Architect
Agile Technology Architects, LLC


On 8/24/2011 11:34 AM, sjl wrote:
> Jim
>
> The IBM i Access file transfer program has a table creation wizard which
> will create the table and then upload the spreadsheet data to the created
> table.  All you have to do to use it is to put a valid (IBM i) column name
> at the top of each spreadsheet column and then use it to create the transfer
> request.
>
> After opening Data Transfer to System i, on the menu bar click Tools ->
> Create System i Database File.
>
> In the test I just ran, I had to save my spreadsheet as a .XLS (Excel '97 -
> 2003 format) in order to use it with the wizard, since our system is on V5R4
> and it can only handle up to BIFF8 files.
>
> - sjl