Hi Majid you need to provide a little more context. Where is the data coming from and what format is the data coming to you as? Ideally how was it generated? Also just to set expectations, moving this much data around can be its own project. It's not quite a double-click on a file into Excel.
FYI as we get started note that it is likely that you'll need to use a different file format than Excel's. As you found out, the legacy .xls format can only hold 64K rows. The newer .xlsx format can handle more but still only about 1M (~ 2^30). The the most common format for sharing large datasets is CSV and more recently JSON, XML, and Parquet. There are also MSSQL-to-MSSQL server formats if you control both sides.
When you say the import of the .xlsx format the data did not import correctly, can you be more specific? As above it's unlikely this will be the format you want to use for loading 1 B rows data into your database but sharing this information would at least provide some context about your data, what you are doing, and what's happening to your data when you do so.