Can i import data from portal to Access2010 (1 Viewer)

lokanathas

Registered User
Joined
Aug 11, 2017
Messages
23
Hi,

Kindly let me know is there any possibility where i can import from Portal( with URL) to Access 2010.
i don't have any idea is this possible through Macro or SQL
 

vedika

Registered User
Joined
Jan 24, 2019
Messages
11
Exporting Data from Microsoft Access 2010

1. Launch Micorsoft Access and open Database*
2. Open ODBC Datasource, click on Advanced tab and*add* 'SuppressInfoForDataTypes=nvarchar'. This property will instruct*the ODBC driver that datatype for the nvarchar datatype should not returned for this specific connection.* Suppression only applies to returning data type information from the OBDC driver. The application is still free to use the datatype in column declarations and when retrieving result sets.
3.* create table accesstab*(col1 long integer, col2 text (255) in* Microsoft*Access and insert row.
4. *Highlight table accesstab right click* -. Export ->ODBC Database ->* Machine Data Source ->Sybase IQ Datasource -> OK
5. Verify export by login into* SAP IQ database**
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom