Register table problem

[satya pal]

Dear all

 

I am facing some issue with register table , pl. suggest me

 

SUB import

Dim filepath ,filename As String ' File path declare

filepath = FileOpenDlg("","","txt","Open Txt")

filename = PathToFileName$(filepath)

Note filepath

Register Table filepath

Type "tab"

Into "AALUMS"

 end sub

[Joshua Moloney]

Register table """ & filepath & """ [some details on type here e.g. TYPE ASCII Delimiter 9 Titles Charset] into "C:\...\AALUMS.TAB"

>>> satya pal <satyap...@gmail.com> 6/24/2009 1:00 pm >>>

[Jones, Christopher]

Try something like this:

 

Dim sCommand as String

filepath = FileOpenDlg("","","txt","Open Txt")

filename = PathToFileName$(filepath)

 

sCommand  = "Register Table " + Chr$(34) +  filepath + Chr$(34) + " TYPE ASCII Delimiter 9 Titles Charset " + Chr$(34) + "WindowsLatin1" + Chr$(34) + " Into " + Chr$(34) + filepath + Chr$(34) + ".TAB"

Run Command sCommand

 

Chris

IMPORTANT - This email and the information that it contains may be confidential, legally privileged and protected by law. Access by the intended recipient only is authorised. Any liability (in negligence or otherwise) arising from any third party acting, or refraining from acting, on any information contained in this email is hereby excluded. If you are not the intended recipient, please notify AmlinComm...@amlin.co.uk immediately then delete it and do not disclose the contents to any other person, use it for any purpose or store or copy the information in any medium. Copyright in this email and attachments created by us belong to Amlin plc and/or one or more of its subsidiaries (Amlin Group). The author also asserts the right to be identified as such and object to any misuse.

The Amlin Group prohibits and takes steps to prevent its email systems from being used to view, store or transmit offensive, obscene or discriminatory material. If this message contains inappropriate material please report it immediately to AmlinComm...@amlin.co.uk. The Amlin Group records, monitors and may inspect messages that use its telecoms systems in order to protect its information, interests and reputation. Any message sent by you to or within the Amlin Group may therefore be viewed and may be acted upon. Of the companies within the Amlin Group, Amlin Underwriting Limited, Amlin Underwriting Services Limited, Amlin Insurance Services Limited and Amlin Plus Limited are authorised and regulated by the Financial Services Authority.

This email has been sent by a member of staff of one or more of the following Amlin Group companies: Amlin plc. Registered in England and Wales no. 2854310 Amlin Underwriting Limited. Registered in England and Wales no. 2323018 Amlin Underwriting Services Limited. Registered in England and Wales no. 422615 Amlin Insurance Services Limited. Registered in England and Wales no. 2739220 Amlin Plus Limited. Registered in England and Wales no. 4729659 Registered Offices: St Helen's, 1 Undershaft, London EC3A 8ND, United Kingdom Amlin plc switchboard: 020 7746 1000 Web Site: http://www.amlin.com

[satya pal]

Thanks