Using 9.5, 64-bit. I have an Excel spreadsheet that I want to do a Gateway Import. I want RBase to create the import table on the fly because I have no idea how many columns or what datatype they will be. I use this type of command:
GATEWAY IMPORT XLS .vfilename CREATE TEMP tmpGateway OPTION SHOW_PROGRESS ON It works, sorta... The problem is that every column is TEXT 10. That truncates alot of my data. I don't see an option to specify the width of every column. I need the length to be a very large TEXT column, or better yet a NOTE. I'm thinking my only other option is to pre-define a temp table with hopefully the maximum number of columns that I could possibly have. Any other ideas? Karen
