looking to create external table using excel file. But the 32bit import and export doesn't show up. I can only see 64bit
The Excel to SQL import is a Microsoft process and not specific to Laserfiche.
Run the SQL Server Import and Export Wizard is Microsoft's instructions for importing. That link has a note that states that the 32 bit importer may not be installed by default and you have to add that feature.
What product are you needing to connect with SQL? Did you install the x86 version on an x64 machine?
You need to use the Microsoft Open Database Connectivity (ODBC) Data Source Administrator tool (Odbcad32.exe):
The 32-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\SysWoW64 folder.
The 64-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\System32 folder.
They have avante sql express installed on a 64bit 2008r2 server. In the instructions for creating an external ]table connection using an excel file, it says to use Import and Export 32bit. I only see Import and Export 64bit. Instructions say that I HAVE to use 32bit. How can I get the Import and Export 32bit for sql express? I even went to the avante installation, selected other components and installed 32bit sql and still doesn't show up.
see below on instructions:
attached file on created external table based on excel file